摘要：
update jwpz_zidianzy a set leibiedm=(select leibiedm from jwpz_zidianlb where jwpz_zidianlb.id=a.zidianlb ) 阅读全文
摘要：
1. 复制表结构及其数据： create table table_name_new as select * from table_name_old 2. 只复制表结构： create table table_name_new as select * from table_name_old where 阅读全文