1 -- 找出各个年份的数据,并将其插入到分区表
2 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2017';
3 INSERT INTO t_user_data_2017 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2017';
4 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2018';
5 INSERT INTO t_user_data_2018 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2018';
6 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2019';
7 INSERT INTO t_user_data_2019 select * from t_sys_user where DATE_FORMAT(create_time,'%Y') = '2019';