Learning PHP and MySQL
Example 16-8 SQL to create the users table (may have already been created
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`username` varchar(45) NOT NULL,
`password` varchar(32) NOT NULL, PRIMARY KEY (`user_id`));
SQL code returns, again, that the query value was OK.
Query OK, 0 rows affected (0.02 sec)
Posted by on 09/27 at 11:40 AM
Next entry: Example 16-9 Inserting sample data for the tables
Previous entry: Example 16-7 SQL to create the comments table