mysql> select count(id) total from applicants;| total || 0 |1 rowin set (0.00 sec)
+-------++-------+1 row in set (0.00 sec)
mysql> select count(id) tota
我正在尝试删除mysql 5.1表中的重复行delete from sessions o where exists (select * from sessions i where i.data=o.data and i.id<>o.id);
但是它似乎不起作用,我读到在mysql中使用表别名的delete语句是不可能的,但这是如何工作的:?