mysql 版本 4.018
执行如下语句:
select * from tobjectlist where fsSvobjNo exists (select fsSvobjNo from tobjectindex where fsSvobjNo = tobjectlist .fsSvobjNo)
报如下错误:
Error Code : 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 exists (select fsSvobjNo from tobjectindex where fsSvobjNo
(0 ms taken)
执行如下语句:
select * from tobjectlist where fsSvobjNo exists (select fsSvobjNo from tobjectindex where fsSvobjNo = tobjectlist .fsSvobjNo)
报如下错误:
Error Code : 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 exists (select fsSvobjNo from tobjectindex where fsSvobjNo
(0 ms taken)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货