title: mysql -> insert into tbl (select from another table) and some default values
body: <p>As the title says, I am trying to insert into one table selecting values from another table and some default values. </p>
  
  <pre><code>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'))
  </code></pre>
  
  <p>The first query gives a mysql error and the second one gives column count does not match. </p>
  
  <p>What do I need to do?</p>