批量修改库表字符串脚本

[quote]生成可执行语句[/quote]

mysql -uroot -p67457e226a1a15bd -e 'use jira636;show tables;'|awk -F'|' '{print "mysql -uroot -p67457e226a1a15bd -e \"use jira636;alter table "$1 " default character set utf8;\""}' >[color=orange]batch_mysql_table_charset.sh[/color]

chmod 755 batch_mysql_table_charset.sh

[quote]执行脚本batch_mysql_table_charset.sh[/quote]