触发器按月分表时怎么只插入新表，旧表不插

Question

使用触发器按月创建新表时，怎么只插入触发器新建的表，数据不往旧表里面插入

Answer 1

这篇 博文 写的很详细 https://blog.csdn.net/qq_36396104/article/details/80469997?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164733402316780357292413%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=164733402316780357292413&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-1-80469997.142^v2^pc_search_result_cache,143^v4^register&utm_term=mysql%E8%A7%A6%E5%8F%91%E5%99%A8&spm=1018.2226.3001.4187