title: Missing comma before start of a new alter operation. (near "CHARACTER SET")
body: <h1>Mysql - phpmyadmin</h1>
  <p>What's wrong with this query?</p>
  <pre><code>ALTER TABLE `invoices` 
  CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') 
  CHARACTER SET `utf8` COLLATE `utf8_general_ci` NOT NULL DEFAULT `due`;
  </code></pre>
  <p>I am getting this error:</p>
  <p><strong>Missing comma before start of a new alter operation. (near &quot;CHARACTER SET&quot;)</strong> and not able to run this query on live server. Query was generated when I changed the table structure on my localhost during development.</p>
  <p>I also tried below query mentioned in many threads but it also give same above error:</p>
  <p><code>ALTER TABLE `invoices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;</code></p>