1.删除语句 

 

DELETE FROM table_name

TRUNCATE TABLE table_name

 

2.插入语句

INSERT INTO user1(,,user1.sex)SELECT (user.id,,user.sex)FROM user where user.id <= 250000

INSERT INTO user2(,,user2.sex)SELECT (user.id,,user.sex)FROM user where user.id > 250000