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

Question

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 1

You simply have to do:

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

Answer 2

If you want to insert all the columns then

insert into def select * from abc; 

here the number of columns in def should be equal to abc.

if you want to insert the subsets of columns then

insert into def (col1,col2, col3 ) select scol1,scol2,scol3 from abc;  

if you want to insert some hardcorded values then

insert into def (col1, col2,col3) select 'hardcoded value',scol2, scol3 from abc;