报错如下: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 '' at line 1报上面的错.针对这个句子$sql = "UPDATE zsd0c SET zsd0c.3天销售 = \"Y\",zsd0c

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/15 04:13:25

报错如下: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 '' at line 1报上面的错.针对这个句子$sql = "UPDATE zsd0c SET zsd0c.3天销售 = \"Y\",zsd0c
报错如下:
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 '' at line 1
报上面的错.针对这个句子
$sql = "UPDATE zsd0c SET zsd0c.3天销售 = \"Y\",zsd0c.10天销售 = \"Y\",zsd0c.28天销售 = \"Y\" where 累计工作日 >= $M-3 and 累计工作日= $M-3 and 累计工作日

报错如下: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 '' at line 1报上面的错.针对这个句子$sql = "UPDATE zsd0c SET zsd0c.3天销售 = \"Y\",zsd0c
如果你的 sql 语句没有错误,是否在连接到 mysql 的时候进行了 set names charset 的操作,
比如 set names 'utf-8'.另外,如果你的表结构不用中文就更专业了.