我插入一条记录到PHP查询与一个表,它工作得很好。
$Query="INSERT INTO siparisler (firma)
SELECT musteri_ismi from musteri_ekle where musteri_id='$Musteri_id'";
但是,当我尝试插入来自第二个表的查询时,它不起作用:
$Query="INSERT INTO siparisler (firma,urun)
SELECT musteri_ismi from musteri_ekle where musteri_id='$Musteri_id',
urun_id from urun_ekle where urun_id='$Urun_id'";
将来自不同表的两个数据插入到一个查询中的方法是什么?
发布于 2018-06-23 03:47:47
INSERT
INTO siparisler (firma, urun)
SELECT
(
SELECT musteri_ismi
from musteri_ekle
where musteri_id='$Musteri_id'
) AS firma,
(
SELECT urun_id
from urun_ekle
where urun_id='$Urun_id'
) AS urun ;
https://stackoverflow.com/questions/50988982
复制相似问题