Learning PHP and MySQL
Monday, September 25, 2006
Example 13-6 Creating the users table to store login information
CREATE TABLE `users` (
`user_id` INT NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR(100),
`last_name` VARCHAR(100),
`username` VARCHAR(45),
`password` CHAR(32), PRIMARY KEY (`user_id`));
This code returns:
Query OK, 0 rows affected (0.23 sec)
Posted by krautgrrl on 09/25 at 11:28 AM
Chapter 13 Code • (0) Comments • (0) Trackbacks • Permalink
Chapter 13 Code • (0) Comments • (0) Trackbacks • Permalink
Statistics
This page has been viewed 407354 times
Page rendered in 0.1292 seconds
Total Entries: 224
Total Comments: 16
Total Trackbacks: 307338
Most Recent Entry: 09/27/2006 12:39 pm
Most Recent Comment on: 10/26/2007 10:00 am
Total Members: 2
Total Logged in members: 0
Total guests: 10
Total anonymous users: 0
Most Recent Visitor on: 05/19/2012 06:28 am
The most visitors ever was 1103 on 11/20/2007 12:50 pm
