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

You simply have to do:

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