1
hiths 2019-11-25 17:38:55 +08:00
|
2
vinHty 2019-11-25 21:30:05 +08:00
接楼上:
select tem.* into people from (balabalaa) as tem; #没跑过 可以试试 - - |
3
jay0726 2019-11-25 22:02:13 +08:00
应该用 insert select 将查询结果写入数据表,sql 如下
insert into people(pid, pname, cid) select customer.id, customer.name, company.cid from customer inner join company on customer.cname = company.cname; |
4
shavy OP 谢谢楼上各位的回复!
|
5
JunoNin 2019-11-26 08:51:48 +08:00 via Android
广州的?
|