title: MySQL: Multiple Inserts for a single column
body: <p>I'm looking for a way to do multiple row inserts when I'm only inserting data for a single column.</p>
  
  <p>Here is the example table:</p>
  
  <pre><code>+-------+-------------+------+-----+---------+----------------+
  | Field | Type        | Null | Key | Default | Extra          |
  +-------+-------------+------+-----+---------+----------------+
  | id    | tinyint(4)  | NO   | PRI | NULL    | auto_increment | 
  | name  | varchar(40) | NO   | UNI | NULL    |                | 
  +-------+-------------+------+-----+---------+----------------+
  </code></pre>
  
  <p>I want to be able to insert something like ('admin', 'author', 'mod', 'user', 'guest') into the name column for each row.</p>
  
  <p>The MySQL documentation shows that multiple inserts should be in the format:</p>
  
  <pre><code>INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
  </code></pre>
  
  <p>However my statement ends up looking like this:</p>
  
  <pre><code>INSERT INTO User_Role(name) VALUES ('admin','author','mod','user','guest');
  </code></pre>
  
  <p>And I get the following:<br>
  ERROR 1136 (21S01): Column count doesn't match value count at row 1</p>
  
  <p>Meaning that it thinks I'm trying to do a single row insert.</p>
  
  <p>I'm not sure if I'm just missing something simple here, but I don't see anything in particular in the MySQL docs for this use case.</p>