批量修改表中字段的排序规则

sql命令

修改字段的
===
SELECT
    CONCAT(
    'alter table `',
    table_name,
    '` modify `',
    column_name,
    '` ',
    data_type,
    ( CASE WHEN data_type like '%text%' THEN ' ' ELSE CONCAT ( '(', character_maximum_length, ') ' ) END ),
    'character set utf8mb4 collate utf8mb4_bin',
    ( CASE WHEN is_nullable = 'no' THEN ' not null' ELSE '' END ),
    ( CASE WHEN IFNULL( column_comment, '' ) = '' THEN '' ELSE CONCAT ( ' comment \'', column_comment, '\'' ) END ),
    ';' 
) AS `sql`
FROM
    information_schema.`COLUMNS` 
WHERE
    table_schema = zhegnsn
    AND collation_name = 'utf8mb4_general_ci';

===============================
修改表的
===

SELECT
    CONCAT( 'ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' COLLATE=utf8mb4_bin;' ) 'sql' 
FROM
    information_schema.`TABLES` 
WHERE
    table_schema = zhegnsn AND table_collation = 'utf8mb4_general_ci';