请高手指点,我对一张表查询后再更新,查询是子查询,报错: You can't specify target table 'a_table' for update in from clause 完整SQL语句是 UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
先上错误 无法联接数据库 java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......