总体配置如图:
2
SELECT table_name
FROM information_schema.tables
WHERE table_schema ='模式名' and table_name LIKE '需分表表名%';
3.
SELECT distinct CONCAT("XXX_", SUBSTR(CREATE_TIME FROM 1 FOR 10) )as table_name FROM XXX.XXX
45
注意使用INSERT ··· ON DUPLICATE KEY UPDATE这个sql时请确保在建表时正确创建了主键