如果两个表结构完全一样的,用insert into data2.table2 select * from data1.table1 如果结构不一样或者你要指定字段,用insert into data2.table2(字段1,字段2,字段) select 字段j,字段k,字段m from data1.table1PS:我的淘宝店铺新开业,经营各种桌游,棋牌,希望大伙儿能来看看!http://201314yes.taobao.com/
posted on 2012-02-17 10:13 jenney.qiu 阅读(7984) 评论(0) 编辑 收藏 举报
Powered by: 博客园 Copyright © 2024 jenney.qiu Powered by .NET 8.0 on Kubernetes