请问以下SQL语句错在哪里?在SQLSERVER中没有错误
来源:百度知道 编辑:UC知道 时间:2024/05/22 05:37:47
IF EXISTS (
SELECT *
FROM `dmcb_zxz_10`
WHERE (RiQiShiJian = `07101809`
AND IIiii = `58317`)
)
UPDATE `dmcb_zxz_10` SET (Z_O_AWS_ST_C5_10 = `09:11` ,
Z_O_AWS_ST_C5_SIZE_10 = `429` ) WHERE (RiQiShiJian = `07101809` AND IIiii = `58317`) ELSE INSERT INTO `dmcb_zxz_10` ( RiQiShiJian, IIiii, Z_O_AWS_ST_C5_10, Z_O_AWS_ST_C5_SIZE_10 )
VALUES (
`07101809` , `58317``09:11` , `429`
)
以上SQL语句在SQL SERVER 中没有错误,但在MYSQL中报错
错误信息是:
MySQL 返回:
#1064 - You have an error in your SQL syntax near 'IF EXISTS (
SELECT *
FROM `dmcb_zxz_10`
WHERE (RiQiShiJian = `07101809`
' at line 1
SELECT *
FROM `dmcb_zxz_10`
WHERE (RiQiShiJian = `07101809`
AND IIiii = `58317`)
)
UPDATE `dmcb_zxz_10` SET (Z_O_AWS_ST_C5_10 = `09:11` ,
Z_O_AWS_ST_C5_SIZE_10 = `429` ) WHERE (RiQiShiJian = `07101809` AND IIiii = `58317`) ELSE INSERT INTO `dmcb_zxz_10` ( RiQiShiJian, IIiii, Z_O_AWS_ST_C5_10, Z_O_AWS_ST_C5_SIZE_10 )
VALUES (
`07101809` , `58317``09:11` , `429`
)
以上SQL语句在SQL SERVER 中没有错误,但在MYSQL中报错
错误信息是:
MySQL 返回:
#1064 - You have an error in your SQL syntax near 'IF EXISTS (
SELECT *
FROM `dmcb_zxz_10`
WHERE (RiQiShiJian = `07101809`
' at line 1
SELECT *
FROM dmcb_zxz_10
WHERE (RiQiShiJian = '07101809'
AND IIiii = '58317')
表名外面不要单引号吧.
原因:语法错误.sql语法注意大小写
把 ` 变成 "