CREATE TABLE comment (
`comment_id` mediumint(8) unsigned NOT NULL auto_increment,
`comment_flashid` mediumint(10) unsigned NOT NULL default '',//here unsigned
`comment_name` mediumint(8) NOT NULL default '',
`comment_date` int(10) NOT NULL default '',
`comment_content` text NOT NULL,
PRIMARY KEY (`comment_id`)
)TYPE=MyISAM;
`comment_id` mediumint(8) unsigned NOT NULL auto_increment,
`comment_flashid` mediumint(10) unsigned NOT NULL default '',//here unsigned
`comment_name` mediumint(8) NOT NULL default '',
`comment_date` int(10) NOT NULL default '',
`comment_content` text NOT NULL,
PRIMARY KEY (`comment_id`)
)TYPE=MyISAM;
`comment_id` mediumint(8) unsigned NOT NULL auto_increment,
`comment_flashid` mediumint(10) unsigned NOT NULL ,
`comment_name` mediumint(8) NOT NULL ,
`comment_date` int(10) NOT NULL ,
`comment_content` text NOT NULL,
PRIMARY KEY (`comment_id`)
)TYPE=MyISAM;
no " default '' "
`comment_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`comment_flashid` MEDIUMINT( 10 ) UNSIGNED NOT NULL default '',
`comment_name` MEDIUMINT( 8 ) NOT NULL default '',
`comment_date` INT( 10 ) NOT NULL default '',
`comment_content` TEXT NOT NULL
) TYPE = MYISAM ;
==========================================================================
你用这个看看!
`comment_id` mediumint(8) unsigned NOT NULL primary key auto_increment,
`comment_flashid` mediumint(10) unsignend NOT NULL,
`comment_name` mediumint(8) NOT NULL,
`comment_date` int(10) NOT NULL,
`comment_content` text NOT NULL,
PRIMARY KEY (`comment_id`)
)TYPE=MyISAM;