今天搞 PHP 开发的时候,搞出了这个错误:我执行的语句是:INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES (98,'test','test','test');结果竟然返回错误:1146:Table 'mysite.writings' doesn't exist大家看清楚了,我插入的是 tb_Replies 表,结果竟然返回 writings 表不存在(事实上我数据库里根本没 writings 这表)。而且,虽然返回了错误,数据却是插入成功。大家有没有遇到过类似的问题 ?该如何解决?
`R_ID` int(10) unsigned NOT NULL auto_increment,
`R_Name` varchar(15) NOT NULL,
`R_Contact` varchar(30) NOT NULL,
`R_Content` varchar(400) NOT NULL,
`R_Time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`W_ID` int(10) unsigned NOT NULL,
`F_R_ID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY USING BTREE (`R_ID`),
KEY `W_ID` USING BTREE (`W_ID`),
KEY `F_R_ID` USING BTREE (`F_R_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=211 DEFAULT CHARSET=utf8
另外show triggers 看一下。mysql> CREATE TABLE `tb_Replies` (
-> `R_ID` int(10) unsigned NOT NULL auto_increment,
-> `R_Name` varchar(15) NOT NULL,
-> `R_Contact` varchar(30) NOT NULL,
-> `R_Content` varchar(400) NOT NULL,
-> `R_Time` timestamp NOT NULL default CURRENT_TIMESTAMP,
-> `W_ID` int(10) unsigned NOT NULL,
-> `F_R_ID` int(10) unsigned NOT NULL default '0',
-> PRIMARY KEY USING BTREE (`R_ID`),
-> KEY `W_ID` USING BTREE (`W_ID`),
-> KEY `F_R_ID` USING BTREE (`F_R_ID`)
-> ) ENGINE=MyISAM AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.03 sec)mysql> INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES
(98,'test','test','test');
Query OK, 1 row affected (0.00 sec)mysql>