[quote]生成可执行语句[/quote]
[quote]执行脚本batch_mysql_table_charset.sh[/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]