mysql怎么修改表前綴

ALTER?TABLE?原表名?RENAME?TO?新表名;

ALTER?TABLE?old_post?RENAME?TO?new_post;

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;