title: mysql 1064 error SYNTAX ERROR
body: <p>I keep getting this error every time i try to create a table in my sql database:</p>
  
  <p>Error in query (1064): Syntax error near 'CREATE TABLE IF NOT EXISTS <code>users</code> ( <code>id</code> int(10) NOT NULL AUTO_INCREMENT, `' at line 2</p>
  
  <p>Could I get some help with this?</p>
  
  <pre><code>use luke_f_db
  CREATE TABLE IF NOT EXISTS `users` (
   `id` int(10) NOT NULL AUTO_INCREMENT,
   `username` varchar(50) NOT NULL,
   `email` varchar(50) NOT NULL,
   `password` varchar(50) NOT NULL,
   `trn_date` datetime NOT NULL,
   PRIMARY KEY (`id`)
   );
  </code></pre>