delete from gb_main a where a.gb_read = 0 and a.gb_reid not in (select b.gb_id from gb_main b)
执行的话,提示:
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 'where a.gb_read = 0 and a.gb_reid not in (select b.gb_id from gb_main b)' at line 1
(0 ms taken)
是不是delete 后面不能跳in?select * from gb_main a where a.gb_read = 0 and a.gb_reid not in (select b.gb_id from gb_main b) 这一句是可以执行的这些数据全在一张表里面
执行的话,提示:
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 'where a.gb_read = 0 and a.gb_reid not in (select b.gb_id from gb_main b)' at line 1
(0 ms taken)
是不是delete 后面不能跳in?select * from gb_main a where a.gb_read = 0 and a.gb_reid not in (select b.gb_id from gb_main b) 这一句是可以执行的这些数据全在一张表里面
解决方案 »
- mysql 密码正确,程序运行一段时间后就提示密码不对,重启就好了
- mysql用户权限问题
- 求一SQL语句,删除 字段中 字数大于5的内容
- 关于最新版本postgresql的问题:通过postgresql-8.3.7-1-linux.bin安装的...
- 一个查询命令的问题:如何查询,,指定的多行记录???无ID号....
- mysql中如何知道某个字段特定位置的字符
- 哪里能下载到WIN2K上的mysql?我刚下载的mysql-4.1.0-alpha.zip里面没有setup.exe这个文件?
- 初来本版,散分求教,window下安装了mysql,在哪里可以看到数据。
- mysql分区问题
- 关于hql语句的问题
- 求mysql-max-5.0.18-linux-i686-glibc23.tar.gz,万分感谢!!急用!!!!
- 每天1万的数据要添加或者更新,mysql行吗
delete from gb_main a where (a.gb_read = 0) and (a.gb_reid not in (select b.gb_id from gb_main b))
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 'where (a.gb_read = 0) and (a.gb_reid not in (select b.gb_id from gb' at line 1
(0 ms taken)