我有以下SQL查询:
INSERT INTO site_city_address (`cityName`, `cityCode`, `stateId`) VALUES (SELECT a.city, a.cityCode, b.stateId
FROM site_address_dropdown a INNER JOIN site_state_address b
ON a.state = b.stateName);
我知道这可能是错误的。我想做的是将a.city,a.cityCode和b.stateId的值作为cityName,cityCode和stateId插入shopious_city_address中。
我该怎么做?
最佳答案
您可以在values
之后指定select
或insert
。您的情况下,请省略values
:
INSERT INTO site_city_address
(`cityName`, `cityCode`, `stateId`)
SELECT a.city, a.cityCode, b.stateId
FROM site_address_dropdown a
INNER JOIN
site_state_address b
ON a.state = b.stateName;
关于mysql - 从选择语句向表中插入值,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/15766258/