直接上代码
mysql从一个表中查询插入另一个表
insert into t_centre_copy ( doc_id, client_name, month_sale_num, address, area_id, call_center, centre_name, distance, cate_name ) ( select doc_id, client_name, month_sale_num, address, area_id, call_center, centre_name, distance, cate_name from t_centre group by doc_id )
两个表关联再更新其中一个表
update t_centre_copy, t_map_client_mt_shanghai_mark set t_centre_copy.id = t_map_client_mt_shanghai_mark.id where t_centre_copy.doc_id = t_map_client_mt_shanghai_mark.doc_id
如对本文有疑问, 点击进行留言回复!!
服务器Centos部署MySql并连接Navicat过程详解
网友评论