ALTER TABLE old_post RENAME TO new_post; Sql查詢語句有一個缺點，那就是一句SQL語句只能修改一張數據庫的表名,如果你要精確修改某一張表，很好用。如果數據庫表很多的話，比較麻煩。
但是我們可以通過一條語句一次性生成所有的sql語句：
select concat('alter table ',table_name,' rename to ',table_name) from information_schema.tables where table_name like'dmsck_%'; 生成語句如下：
alter table dmsck_acategory rename to dmsck_acategory; alter table dmsck_address rename to dmsck_address; alter table dmsck_article rename to dmsck_article; alter table dmsck_attrcategory rename to dmsck_attrcategory; alter table dmsck_attribute rename to dmsck_attribute; alter table dmsck_brand rename to dmsck_brand; alter table dmsck_cart rename to dmsck_cart; alter table dmsck_category_attr rename to dmsck_category_attr; alter table dmsck_category_goods rename to dmsck_category_goods; alter table dmsck_category_store rename to dmsck_category_store; alter table dmsck_collect rename to dmsck_collect; alter table dmsck_comment rename to dmsck_comment; alter table dmsck_coupon rename to dmsck_coupon; alter table dmsck_coupon_sn rename to dmsck_coupon_sn; alter table dmsck_enterprise rename to dmsck_enterprise; alter table dmsck_filmstrip rename to dmsck_filmstrip; alter table dmsck_friend rename to dmsck_friend; alter table dmsck_function rename to dmsck_function; alter table dmsck_gattribute_rule rename to dmsck_gattribute_rule; alter table dmsck_gcategory rename to dmsck_gcategory; alter table dmsck_goods rename to dmsck_goods; alter table dmsck_goods_attr rename to dmsck_goods_attr; alter table dmsck_goods_bak rename to dmsck_goods_bak; alter table dmsck_goods_down_log rename to dmsck_goods_down_log; alter table dmsck_goods_image rename to dmsck_goods_image; alter table dmsck_goods_old rename to dmsck_goods_old; alter table dmsck_goods_qa rename to dmsck_goods_qa; alter table dmsck_goods_spec rename to dmsck_goods_spec; alter table dmsck_goods_statistics rename to dmsck_goods_statistics; alter table dmsck_groupbuy rename to dmsck_groupbuy; alter table dmsck_groupbuy_log rename to dmsck_groupbuy_log; alter table dmsck_keyword rename to dmsck_keyword; alter table dmsck_mail_queue rename to dmsck_mail_queue; alter table dmsck_member rename to dmsck_member; alter table dmsck_message rename to dmsck_message; alter table dmsck_module rename to dmsck_module;
