sql如下:
delete from area_table where id = select max(id) from area_table -- 错误
delete a from area_table a ,(select max(id) as max_id from area_table) b
where a.id=b.max_id -- 正常
版本:5.7.14
sql如下:
delete from area_table where id = select max(id) from area_table -- 错误
delete a from area_table a ,(select max(id) as max_id from area_table) b
where a.id=b.max_id -- 正常
版本:5.7.14