一、问题展示
实际这里是是一个delete in语句。
mysql> show processlist;
+----+------+-----------+------+---------+------+-----------+-----------------------------------------------------------------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+------+-----------+------+---------+------+-----------+-----------------------------------------------------------------------------+-----------+---------------+
| 2 | root | localhost | ttt | Query | 14 | preparing | delete from testout2 where id not in(select id from testin2 where name='t') | 0 | 37151 |
| 7 | root | localhost | NULL | Query | 0 | starting | show processlist |