copy column from one table and insert in another

Question

I have 2 tables: publications and books.

Currently, the table publications is empty.

I need to select all the books in the 'books' table with volume "26" and insert it in the publications table. I should also populate the column publications.component with 'thesorus'

I tried the sql below but it does not seem correct:

INSERT INTO publications (book_fk, component) VALUES (SELECT book_id FROM books WHERE volume = 26, "thesorus");

Any suggestion is most appreciated

Maxim Krizhanovsky · Accepted Answer · 2012-05-14 10:44:41Z

3

The correct syntax is:

INSERT INTO publications (book_fk, component) SELECT book_id, 'thesorus' FROM books WHERE volume = 26

answered May 14, 2012 at 10:44

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

triclosan · Accepted Answer · 2012-05-14 10:45:34Z

INSERT INTO publications (book_fk, component) SELECT book_id, 'thesorus' FROM books WHERE volume = 26;

php · Accepted Answer · 2013-12-26 12:31:32Z

0

Insert into (field1,field2) select field1, field2 from table1

answered Dec 26, 2013 at 12:31

php

4,4551 gold badge27 silver badges13 bronze badges

Collectives™ on Stack Overflow

copy column from one table and insert in another

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related