create table pms1
(
pmid mediumint(8) unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
poster varchar(25) NOT NULL default '',
receiver varchar(25) NOT NULL default '',
stime datetime NOT NULL default '0000-00-00 00:00:00',
read123 enum('no','yes') default 'no',
content text,
enum('no','yes') default 'no',
newnum tinyint(3) NOT NULL default '0',
PRIMARY KEY(pmid) #主键
);
(
pmid mediumint(8) unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
poster varchar(25) NOT NULL default '',
receiver varchar(25) NOT NULL default '',
stime datetime NOT NULL default '0000-00-00 00:00:00',
read123 enum('no','yes') default 'no',
content text,
enum('no','yes') default 'no',
newnum tinyint(3) NOT NULL default '0',
PRIMARY KEY(pmid) #主键
);
(2)read是个关键字