MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `jsin_DB`.`js_order_goods`( order_id, goods_id, goods_name, product_id, goods_number, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id ) SELECT '7', goods_id, goods_name, goods_sn, product_id, goods_number, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id FROM `jsin_DB`.`js_cart` WHERE session_id = '2' ) [2] => Array ( [error] => Column count doesn't match value count at row 1 ) [3] => Array ( [errno] => 1136 ) ) 高手帮忙看一下,什么原因!
解决方案 »
- 一个困扰了我好久的问题,望高手解答
- [小问题5--迁移mysql这个库]
- mysql 连接时报错,请帮忙解决。。Character set 'gb2312' is not a compiled character set and is
- 用mysql数据库 在页面上提取出来有乱码
- 如何安全的配置和应用MySQL数据库?
- mysql中有没将一个数据集全部导入另一个表的API
- 帮忙看看这条SQL语句写的对不对
- 菜鸟求一句SQL。大家都来看看吧。
- MySQL Control 里面select * from table 只能显示1000条,什么原因阿?在那里配置?
- 数据库转移,我该怎么做?请大家帮着出出主意,谢谢
- 导出mysql中数据库出现了问题 求指教
- 请教 修改mysql数据库、表编码问题
INSERT INTO后面12个字段,SELECT 13个字段,检查一下
INSERT INTO `jsin_DB`.`js_order_goods`
( order_id, goods_id, goods_name, product_id, goods_number, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id ) SELECT '7', goods_id, goods_name, goods_sn, product_id, goods_number, goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id FROM `jsin_DB`.`js_cart` WHERE session_id = '2' ) 多出了goods_sn字段吧