Question

MySQLErrno:1146怎么解决

出现Bad Request. 我也不明白,小站,如今问吧给人留了很多多少告白,在后台删除时,出现:MySQL Query : SELECT COUNT(cid) AS num FROM phpcms_ask_credit WHERE userid=\'36\' MySQL Error : Table \'sq_php.phpcms_ask_credit\' doesn\'t exist MySQL Errno : 1146 Message : MySQL Query Error这是为什么呢,我的数据库出问题,照样因为进级后的问题,请高人指导,我该若何处理,能解哪里,不堪感激!!!

Answer 1

DROP TABLE IF EXISTS `phpcms_ask_credit`;CREATE TABLE `phpcms_ask_credit` (`cid` mediumint(8) unsigned NOT NULL auto_increment,`userid` mediumint(8) unsigned NOT NULL default \'0\',`username` char(20) NOT NULL,`premonth` smallint(5) unsigned NOT NULL default \'0\',`month` smallint(5) unsigned NOT NULL default \'0\',`preweek` smallint(5) unsigned NOT NULL default \'0\',`week` smallint(5) unsigned NOT NULL default \'0\',`addtime` int(10) unsigned NOT NULL default \'0\',PRIMARY KEY(`cid`),UNIQUE KEY `userid` (`userid`),KEY `premonth` (`premonth`,`userid`),KEY `preweek` (`preweek`,`userid`)) TYPE=MyISAM;这个事建表语句，你在后台或者用phpmyadmin运行一下即可该操作有风险请做好数据库备份

Answer 2

my sql中若何创建存储过程，计算随便率性整数N的阶乘

Answer 3

我上了mysql，似乎不见了这个表ask_credit，可否若何建多一个呢

Answer 4

多谢,在后台运行上面的语句后,成功没掉足了.

Answer 5

我的视频是好早进级后出现Bad Request.问下可否应用一致办法来处理这个问题,如可以可否告诉下语句,感激