delete from t where date in (select max(date) from tb);
delete a from t a,(select max(date) as date from t) b where a.date=b.date
mysql> delete from t where date =max(date); 改成==》 delte from t where datae=(select max(date) from t)
mysql> create table t2(delete from t1 where date = (select max(date) from t1)); ERROR 1064 (42000): 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 'delete from t1 where date = (select max(date) from t1))' at line 1 mysql> delete from t1 where date in (select max(date) from t1); ERROR 1093 (HY000): You can't specify target table 't1' for update in FROM clause
mysql> delete from t1 where date = (select max(date) from t1); ERROR 1093 (HY000): You can't specify target table 't1' for update in FROM clause
改成==》
delte from t where datae=(select max(date) from t)
ERROR 1064 (42000): 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 'delete from t1 where date = (select max(date) from t1))' at line 1
mysql> delete from t1 where date in (select max(date) from t1);
ERROR 1093 (HY000): You can't specify target table 't1' for update in FROM clause
ERROR 1093 (HY000): You can't specify target table 't1' for update in FROM clause