利用SQL语句实现将一个表格中的一列放入另一个表格的一列,其中包括将两列内容进行合并并放进另一表格的操作。
NSERT INTO sys_dept_copy1 ( dept_id,parent_id,ancestors,dept_name,dist_code) SELECT
#上面是目标表格,目标列 下面是原始列
city_code,'21','0,21',name,dists_code
FROM
ln_fx_city_p;#原始表格
INSERT INTO sys_dept_copy1 ( dept_id,parent_id,ancestors,dept_name,dist_code) SELECT
county_code,'2109',concat(concat('0,21,2109',','),county_code) ,name,dists_code
FROM
ln_fx_county_p;
#将‘0,21,2109’、county_code两列合并并在中间添加符号,
INSERT INTO sys_dept_copy1 ( dept_id,parent_id,ancestors,dept_name,dist_code) SELECT
town_code,county_code,concat(concat(concat(concat('0,21,2109',','),county_code),','),town_code),name,dists_code
FROM
ln_fx_town_p;
#将‘0,21,2109’、county_code、town_code三列合并并在中间添加符号,
INSERT INTO sys_dept_copy1 ( dept_id,parent_id,ancestors,dept_name,dist_code) SELECT
town_code,town_code,concat(concat(concat(concat('0,21,2109',','),county_code),','),town_code),name,dists_code
FROM
ln_fx_village_p;
INSERT INTO sys_dept_copy1 ( dept_id,parent_id,ancestors,dept_name,dist_code) SELECT
town_code,town_code,concat(concat(concat(concat('0,21,2109',','),county_code),','),town_code),name,dists_code
FROM
ln_fx_naturalvillage_p;