title: How do I add more members to my ENUM-type column in MySQL?
body: <p>The MySQL reference manual does not provide a clearcut example on how to do this.</p>
  
  <p>I have an ENUM-type column of country names that I need to add more countries to. What is the correct MySQL syntax to achieve this?</p>
  
  <p>Here's my attempt:</p>
  
  <pre><code>ALTER TABLE carmake CHANGE country country ENUM('Sweden','Malaysia');
  </code></pre>
  
  <p>The error I get is: <code>ERROR 1265 (01000): Data truncated for column 'country' at row 1.</code></p>
  
  <p>The <code>country</code> column is the ENUM-type column in the above-statement.</p>
  
  <p><b>SHOW CREATE TABLE</b> OUTPUT:</p>
  
  <pre><code>mysql&gt; SHOW CREATE TABLE carmake;
  +---------+---------------------------------------------------------------------+
  | Table   | Create Table
  +---------+---------------------------------------------------------------------+
  | carmake | CREATE TABLE `carmake` (
  `carmake_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` tinytext,
  `country` enum('Japan','USA','England','Australia','Germany','France','Italy','Spain','Czech Republic','China','South Korea','India') DEFAULT NULL,
  PRIMARY KEY (`carmake_id`),
  KEY `name` (`name`(3))
  ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 |
  +---------+---------------------------------------------------------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p><b> SELECT DISTINCT country FROM carmake</b> OUTPUT:</p>
  
  <pre><code>+----------------+
  | country        |
  +----------------+
  | Italy          |
  | Germany        |
  | England        |
  | USA            |
  | France         |
  | South Korea    |
  | NULL           |
  | Australia      |
  | Spain          |
  | Czech Republic |
  +----------------+
  </code></pre>