这些代码是什么意思？

答案:2 悬赏:0 手机版

解决时间 2021-04-16 22:13

提问者网友：绫月
2021-04-15 22:24

Database error: Invalid SQL: update mpshop_plus set `showmore`='0', `tempname`='0', `hangnums`='0', `shownums`='0', `smallw`='0', `smallh`='0', `ord`='0', `sc`='0', `showtime`='0', `onlytj`='0', `cutword`='0', `target`='0', `body`='', `catid`='0', `showmenuid`='0' where menuid='1' and pluslable='modEdit' and pluslocat='index' and plustype='index' and modno='3'
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'no' frameborder='0' marginwidth='0' marginheight='0' width='520' height='150' sr' at line 14
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'no' frameborder='0' marginwidth='0' marginheight='0' width='520' height='150' sr' at line 14)
Session halted.

最佳答案

五星知识达人网友：洒脱疯子
2021-04-15 23:34

update mpshop_plus set `showmore`='0', `tempname`='0', `hangnums`='0', `shownums`='0', `smallw`='0', `smallh`='0', `ord`='0', `sc`='0', `showtime`='0', `onlytj`='0', `cutword`='0', `target`='0', `body`='', `catid`='0', `showmenuid.....

以上语法错误，字段名不能加引号，如果这些字段的值是数值型的话，也不要加引号。

全部回答

1楼网友：躲不过心动
2021-04-16 00:01

无效的SQL语法，请检查

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！