title: MySQL ERROR 1064： 'DEFAULT CHARACTER SET utf8'
body: <p>I create a database specified its charset as <code>utf8</code> by:</p>
  
  <pre><code>CREATE DATABASE IF NOT EXISTS gtfs;
      DEFAULT CHARACTER SET utf8;
      DEFAULT COLLATE utf8_general_ci;
  </code></pre>
  
  <p>but encounter the following error：</p>
  
  <blockquote>
    <p>ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8' at line 1</p>
  </blockquote>
  
  <p>The version of MySQL:</p>
  
  <pre><code>$ mysql --version
  mysql  Ver 14.14 Distrib 5.6.27, for debian-linux-gnu (x86_64) using  EditLine wrapper
  </code></pre>