mysql not in（一批数据） 数据量大 线上不适合建表
- WBOYOriginal
- 2016-06-06 09:42:061426browse
mysql数据
select * from tb_aabb where id not in (20001,20002,20185,20204,20285,20738,40002,40003,40004,40005,40006,40011,40013);
tb_aabb数据量百万级，同时id总量有1500，线上数据不适合建表联表，这种的有什么解决方案么？谢过了
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-mybatis 执行 INSERT … ON DUPLICATE KEY UPDATE Next article：mysql 请教大神关于插入自增id问题