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

2011年5月6日 - As the title says I am trying to insert into 1 table selecting values from ... You simply have to do: INSERT INTO def (catid, title, page, publish) ...

stackoverflow.com