MySQL Bulk Modify field method

#mysql批量修改字段类型 # Gets the modification statement and stores the use DB to the temporary table; CREATE temporary table Xiugai SELECT   CONCAT (  ' alter TABLE ', TABLE_NAME, ' MODIFY COLUMN ', column_name, ' new type  D ' Efault NULL; '  ) As Col from  information_schema.columns a   WHERE table_schema = ' database name ' and data_type in (' Old type '); #查看获得的语句SELECT * F ROM Xiugai; #mysql外执行, export table contents,-N without column name-e EXECUTE statement mysql-uroot-p-n-e "SELECT * from Xiugai" Database >/home/xiugai. Executed outside Sql#mysql, the Mysql-uroot-p database 
Sometimes we need to do a lot of business tuning to modify all of the database field types
MySQL Bulk Modify field method