Learning PHP and MySQL

Example 16-6 SQL to create the categories table

CREATE  TABLE  `categories`  (
    `
category_id`  int(11)  NOT  NULL  auto_increment,
    `
category`  varchar(150)  NOT  NULLPRIMARY  KEY    (`category_id`)
);

Example 16-6 returns:

Query OK,  0 rows affected  (0.01  sec)

Posted by on 09/27 at 11:36 AM

Next entry: Example 16-7 SQL to create the comments table

Previous entry: Example 16-5 SQL to create the posts table

<< Back to main