insert into select and select insert into

create talbe test1 (sendto varchar(50), name1 varchar(50), name2 varchar(50))

insert into kafa.test1 (sendto, name1, name2) SELECT sendto, name1, name2 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join kafa.region r on s.region_id = r.id left join kafa.region p on s.province_id = p.id )

不需要创建表test1

SELECT sendto, name1, name2 insert into test1 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join kafa.region r on s.region_id = r.id left join kafa.region p on s.province_id = p.id )

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12043693/viewspace-1028696/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12043693/viewspace-1028696/