### 导出化建表语句
mysql -hDB_NAME -uUSERNAME -pPASSWORD -A -N DATABASE -e "
show create table table_name_01 ;
show create table table_name_02 ;
" > show_create_table
### 格式化建表语句
awk '{for (i=2;i<=NF;i++)printf("%s ", $i);print "\n;\n"}' show_create_table|sed "s#\\\n#\n#g" >show_create_table_fix