inserting values to table from select statement

Question

I have the following SQL query:

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);

I know it's possibly wrong. What I want to do is to insert the values of a.city, a.cityCode, and b.stateId as cityName, cityCode, and stateId into the shopious_city_address. How do I do so?

Andomar · Accepted Answer · 2013-04-02 14:08:18Z

You can specify values or select after an insert. In your case, omit 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;

John Woo · Accepted Answer · 2013-04-02 14:08:17Z

remove the VALUES keyword. INSERT INTO...SELECT has the following syntax,

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

Collectives™ on Stack Overflow

inserting values to table from select statement

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related