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

Question

This question already has answers here:

Answer 1

You simply have to do:

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