title: mysql (5.1) insert syntax > col_name=value?
body: <p>Is there a way in mysql to insert a <em>new</em> row in a way that more directly associates a value with its column (rather than <code>table(col_name) values(value)</code>)? When inserting a lot of values at one time, listing them in-line gets rather confusing and leads to errors/mistakes.</p>
  
  <p>I'm looking for something more like <code>UPDATE</code>'s syntax of <code>SET col_name='value'</code>.</p>
  
  <p>I see in the <a href="http://dev.mysql.com/doc/refman/5.1/en/insert.html" rel="noreferrer">mysql doc for INSERT</a> there is the following:</p>
  
  <pre><code>INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
      [INTO] tbl_name
      SET col_name={expr | DEFAULT}, ...
      [ ON DUPLICATE KEY UPDATE
        col_name=expr
          [, col_name=expr] ... ]
  </code></pre>
  
  <p>but that is just for duplicates :/</p>