本帖最后由 zhlw88cn 于 2010-02-01 17:52 编辑
提示如下
MySQL Error
Message: MySQL Query Error
SQL: SELECT * FROM uchome_doing ORDER BY dateline DESC LIMIT 0,5
Error: Table 'a1029100915.uchome_doing' doesn't exist
Errno.: 1146
解决方法
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; |