Learning PHP and MySQL
Wednesday, September 27, 2006
Example 16-7 SQL to create the comments table
CREATE TABLE `comments` (
`comment_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`title` varchar(150) NOT NULL,
`body` text NOT NULL,
`posted` timestamp,
PRIMARY KEY (`comment_id`)
);
Posted by krautgrrl on 09/27 at 11:38 AM
Chapter 16 Code • (0) Comments • (1) Trackbacks • Permalink
Chapter 16 Code • (0) Comments • (1) Trackbacks • Permalink
Statistics
This page has been viewed 375238 times
Page rendered in 0.1354 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: 02/10/2012 11:49 am
The most visitors ever was 1103 on 11/20/2007 12:50 pm
