编程知识 cdmana.com

MySQL utf8 to utf8mb4 (character set conversion, batch change to utf8mb4)

 

 

 

The data name can be changed , Batch generate all tables set to utf8mb4

SELECT
    CONCAT(
        'ALTER TABLE ',
        TABLE_NAME,
        ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'
    )
FROM
    information_schema.`TABLES`
WHERE
    TABLE_SCHEMA = 'opspay';

The results are as follows

2.2 take sql Copy it , Just do it

版权声明
本文为[Fishing alone]所创,转载请带上原文链接,感谢
https://cdmana.com/2020/12/20201224170445553U.html

Scroll to Top