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的存储过程在C中?
- MySQL user表中的Host值为::1,::1是神马意思啊?
- 限制数据大小
- mysqld: Forcing close of thread 急问题
- 请教:如何查看mysql数据定义操作的日志
- My Sql5.0怎么不能创建存贮过程?
- POSTGRESQL的连接的端口号是多少呀?从系统什么地方可以修改和查看其端口状况?
- 执行mysqld_safe --skip-grant-tables &后 出错
- 请教一个缓存命中的问题,Qcache_not_cached和Buffer pool hit rate
- 求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)