title: mysql right syntax to use near
body: <p>I'm very new to php and mysql! So I need you help please!</p>
  
  <p>I want to make a login/registration page and I found a tutorial. But everytime I want to import the table.sql into the database I get the following error:</p>
  
  <pre><code>#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 '( `id` int (5) NOT 
  NULL auto_increment, `usr` varchar (32) NOT NULL defaul' at line 4
  </code></pre>
  
  <p>This is the code of the table:</p>
  
  <pre><code>--
  -- Table structure for table `tz_members`
  --
  CREATE DATABASE IF NOT EXISTS `tz_members` (
  `id` int( 5 ) NOT NULL AUTO_INCREMENT ,
  `usr` varchar( 32 ) NOT NULL default,
  `pass` varchar( 32 ) NOT NULL default,
  `email` varchar( 255 ) NOT NULL default,
  `regIP` varchar( 15 ) NOT NULL default,
  `dt` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY ( `id` ) ,
  UNIQUE KEY ( `usr` )
  ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =6;
  </code></pre>
  
  <p>I hope you can help me!
  Thanks guys!</p>