常用sql记录

修改表编码结构

SELECT
CONCAT("ALTER TABLE `", tt.table_name,"` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;")
AS target_tables
FROM
(
select table_name,table_rows from information_schema.`TABLES` WHERE table_schema = 'ehome_crm_main' and table_collation  = 'utf8_general_ci' order by table_rows desc,table_name
) tt

添加表索引

ALTER TABLE `ehome_business_beta`.`term_clinic`
ADD INDEX `idx_profitid_clinicid`(`test_strip_price_profit_scheme_id`,`is_delete`,`term_clinic_id`,`term_agent_id`) USING BTREE;