美文网首页
常用sql记录

常用sql记录

作者: 闻乐 | 来源:发表于2022-07-11 15:57 被阅读0次

    修改表编码结构

    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;
    

    相关文章

      网友评论

          本文标题:常用sql记录

          本文链接:https://www.haomeiwen.com/subject/iudabrtx.html