How to bulk Modify table field properties in MySQL

There are nearly 300 tables in the test library, and the Fid,uid fields of 278 tables need to be modified.

The workaround is to automatically generate an SQL statement that modifies the properties of the field.

statement used to generate SQL:

Select CONCAT (' ALTER TABLE ', TABLE_NAME, ' modify ', column_name, ' varchar ') from INFORMATION_SCHEMA. COLUMNS where table_schema= ' Castle ' and column_name in (' uid ', ' fid ', ' hid ');

Increase the global variables for the following parameters:

Sort_buffer_size

Tmp_table_size

Read_buffer_size

Read_rnd_buffer_size

Executes the SQL statement.

This column more highlights: http://www.bianceng.cn/database/MySQL/