如果你的这张表没有数据的话可以对这张表进行重新
先备份一下数据库
然后执行一下以下的代码- DROP TABLE uchome_doing;
- CREATE TABLE uchome_doing (
- doid mediumint(8) unsigned NOT NULL auto_increment,
- uid mediumint(8) unsigned NOT NULL default '0',
- username varchar(15) NOT NULL default '',
- `from` varchar(20) NOT NULL default '',
- dateline int(10) unsigned NOT NULL default '0',
- message text NOT NULL,
- ip varchar(20) NOT NULL default '',
- replynum int(10) unsigned NOT NULL default '0',
- mood smallint(6) NOT NULL default '0',
- PRIMARY KEY (doid),
- KEY uid (uid,dateline),
- KEY dateline (dateline)
- ) ENGINE=MyISAM;
复制代码 |