select * from xty_orders a where ORDER_STATUS= '已校对' and PATIENT_ID in
(select PATIENT_ID from xty_orders b where ORDER_STATUS = '已停止' GROUP BY PATIENT_ID HAVING count(PATIENT_ID) > 1)上面检索正常,我改成删除就报错,为什么???
delete from xty_orders a where ORDER_STATUS= '已校对' and PATIENT_ID in
(select PATIENT_ID from xty_orders b where ORDER_STATUS = '已停止' GROUP BY PATIENT_ID HAVING count(PATIENT_ID) > 1)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 'a where ORDER_STATUS= '已校对' and PATIENT_ID in
(select PATIENT_ID from xt' at line 1
(select PATIENT_ID from xty_orders b where ORDER_STATUS = '已停止' GROUP BY PATIENT_ID HAVING count(PATIENT_ID) > 1)上面检索正常,我改成删除就报错,为什么???
delete from xty_orders a where ORDER_STATUS= '已校对' and PATIENT_ID in
(select PATIENT_ID from xty_orders b where ORDER_STATUS = '已停止' GROUP BY PATIENT_ID HAVING count(PATIENT_ID) > 1)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 'a where ORDER_STATUS= '已校对' and PATIENT_ID in
(select PATIENT_ID from xt' at line 1
解决方案 »
- 关于锁表与解锁的疑问
- 数据库恢复求助!
- mysql导入乱码如何解决?
- 插入1000W条20字段数据,最快的方法是什么,请教~!!!!!!!!!!!!!
- 请问大家,让 mysql 连 jdbc 使用事务,可以rollback(),是不是还需要mysql什么特殊设置?
- MySQL5.0存储过程返回2个结果集,在C#中用NextResult,读取不到!急!
- sql,怎么使一条记录排到最后!!
- mysqld-nt卸载问题
- 一个简单的建表存储过程,执行没有错误,但是没有新表生成
- 这个怎么解决 网上的那些都试过了 具体一点
- 请教如何读取word文档内容写到MySQL中
- mysql怎么把b表一个字段里面的字符串拆分作为查询条件的值去a表里面查询
(SELECT PATIENT_ID FROM (select PATIENT_ID from xty_orders b where ORDER_STATUS = '已停止' GROUP BY PATIENT_ID HAVING count(PATIENT_ID) > 1))
DELETE TABLE_A T1 WHERE T1.ID IN (SELECT T2.ID FROM TABLE_A T2);
这样直接关联相同的表删除就会报错,再套一层就好了,例如:
DELETE TABLE_A T1 WHERE T1.ID IN (SELECT ID FROM (SELECT T2.ID FROM TABLE_A T2));