[batch change MySQL table and corresponding codes of fields in the table]

Batch change mysql Table and the corresponding codes of the fields in the table

--01、 Query all tables 
select * from information_schema.`TABLES` where TABLE_SCHEMA = ' Data can be named ';

--02、 Copy table to excel in , adopt excel Generate multiline statements 

--03、 Execute modification 
alter table ` surface 1` convert to character set utf8;
alter table ` surface 2` convert to character set utf8;
alter table ` surface 3` convert to character set utf8;
--…………

The following is transcribed in the reference materials

-- Modify the encoding format of the table 
ALTER TABLE `table` DEFAULT CHARACTER SET utf8;
-- Although the coding format of the table has been modified , However, the encoding format of the field has not been modified , No eggs 
-- This method and use navicat Changing the encoding of a table is similar 

-- Modify the encoding format of the field 
ALTER TABLE `tablename` CHANGE ` Field name 1` ` Field name 2` VARCHAR(36) CHARACTER SET utf8 NOT NULL;
-- But you can only modify one field at a time , More trouble .

-- Modify the coding format of all fields in a table , Table and field change at the same time 
alter table `tablename` convert to character set utf8;
-- Quite handy 

Reference material :https://www.cnblogs.com/marx-luo/p/6713107.html
thank you ！