title: Whats wrong in my sql query?
body: <p>Here I'm trying to create a new table, but I don't know what I did wrong when creating the table.</p>
  
  <p>SQL query:</p>
  
  <pre><code>CREATE DATABASE IF NOT EXISTS wan_ecommerce;
  USE wan_ecommerce
  CREATE TABLE IF NOT EXISTS users (
   user_id int(11) NOT NULL AUTO_INCREMENT COMMENT,
   user_name varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT,
   user_password_hash varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT,
   user_email varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT,
   user_active tinyint(1) NOT NULL DEFAULT '0' COMMENT,
   user_activation_hash varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT,
   user_password_reset_hash char(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT,
   user_password_reset_timestamp bigint(20) DEFAULT NULL COMMENT,
   user_rememberme_token varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT,
   user_failed_logins tinyint(1) NOT NULL DEFAULT '0' COMMENT,
   user_last_failed_login int(10) DEFAULT NULL COMMENT,
   user_registration_datetime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   user_registration_ip varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0',
   PRIMARY KEY (`user_id`),
   UNIQUE KEY user_name (`user_name`),
   UNIQUE KEY user_email (`user_email`)
  ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data';
  </code></pre>
  
  <p>When I run this I get an error. I've  added <code>;</code> after <code>use wan_ecommerce</code>;, but I'm still getting:</p>
  
  <blockquote>
    <p>1064 - 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 '</p>
    
    <p>user_name varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT,</p>
    
    <p>user_passwo' at line 2</p>
  </blockquote>
  
  <p>What am I doing wrong here?</p>
  
  <p>How can I solve this?</p>