mysql -> insert into tbl (select from another table) and some default values

mysql insert-into
wannabeprogrammer picture wannabeprogrammer · May 6, 2011 · Viewed 195.3k times · Source

As the title says, I am trying to insert into one table selecting values from another table and some default values. 

INSERT INTO def (catid, title, page, publish) 
(SELECT catid, title from abc),'page','yes')


INSERT INTO def (catid, title, page, publish) 
VALUES
((SELECT catid, title from abc),'page','yes'))

The first query gives a mysql error and the second one gives column count does not match.

What do I need to do?

Answer

Nican picture Nican · May 6, 2011

You simply have to do:

INSERT INTO def (catid, title, page, publish) 
SELECT catid, title, 'page','yes' from `abc`

Related questions

Adding a line break in MySQL INSERT INTO text

Could someone tell me how to add a new line in a text that I enter in a MySql table? I tried using the '\n' in the line I entered with INSERT INTO statement but '\n' is shown …

Read More
INSERT INTO...SELECT for all MySQL columns

I'm trying to move old data from: this_table >> this_table_archive copying all columns over. I've tried this, but it doesn't work: INSERT INTO this_table_archive (*) VALUES (SELECT * FROM this_table WHERE entry_date < '2011…

Read More
sql - insert into multiple tables in one query

assuming that i have two tables, names and phones and i want to insert data from some input to the tables, in one query- How can it be done? Please, if it can be done, explain the syntax.

Read More