Learning PHP and MySQL

Wednesday, September 27, 2006

Example 16-5 SQL to create the posts table

CREATE  TABLE  `posts`  (
   `post_id`  int(11)  NOT  NULL  auto_increment,
   `category_id`  int(11)  NOT  NULL,
   `user_id`  int(11)  NOT  NULL,
   `title`  varchar(150)  NOT  NULL,
   `body`  text  NOT  NULL,
   `posted`  timestamp, PRIMARY  KEY    (`post_id`)
);

Posted by krautgrrl on 09/27 at 11:35 AM
Chapter 16 Code • (2) Comments • (6) Trackbacks • Permalink

Statistics

This page has been viewed 407375 times
Page rendered in 0.1195 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: 13
Total anonymous users: 0
Most Recent Visitor on: 05/19/2012 06:43 am
The most visitors ever was 1103 on 11/20/2007 12:50 pm

Referrers

Powered by ExpressionEngine