一.查询:
1.使用IN的条件查询:
固定写法
select * from test1 where id in('baJtqdiWLcHDWszV0adIH9R8I2NoCi','Bb9HejPihspkNtoXfsqp3AGZ9AmVMh');
动态查询:
select * from test1 where id in(select id from test1 where name='luojc');
二,删除:
1.删除表中所有数据
DELETE FROM test1;
2.使用IN批量删除
DELETE FROM test1 WHERE id IN('6S29ZNPT3alF7r4J5TwXV6KxYEgT64','7jrXrXZDA8VLINFRWAGo7FSNu2PHnj');