INSERT INTO table2
SELECT * FROM table1
WHERE condition;

institution (OK)

insert into institution
select distinct row_number() over (order by ins_name) as ins_num, ins_name 
from temp;

ins_info (OK)

insert into ins_info
select row_number() over (order by ins_name) as ins_num, manager, phone0 as phone, website 
from temp;

ins_capacity (OK)

insert into ins_capacity
select row_number() over (order by ins_name) as ins_num, caring_num, 
nurse_num, dem_num, long_caring_num, housing_num, providing_num_111
from temp;

type_func

insert into type_func
select 屬性, 收容對象0, 收容對象1, 收容對象2, 收容對象3
from tmp1;

func_web

ins_address

insert into ins_address
select distinct row_number() over (order by ins_name), 
addr, left(addr, 3), dist from temp;

insert into ins_address select distinct row_number() over (order by 屬性), 地址, left(地址, 3), 區域別 from tmp1;

不確定row_number有沒寫錯

user

user_favorite