<div>
This looks like a very similar issue to yours (almost the same!), and there was a solution posted.<br />
<a href="http://stackoverflow.com/questions/4639788/sql-create-table-error" rel="ugc">http://stackoverflow.com/q<wbr />uestions/4<wbr />639788/sql<wbr />-create-ta<wbr />ble-error</a><br />
<br />
I could post what's inside the link, but in the interest of time, it may be faster for you to check it out.
</div>


<div>
<div class="content wysiwyg-content">
Can someone tell me where my error is and how and what to change it to, so I don't have the error?<br />
<br />
Error<br />
<br />
SQL query:<br />
<br />
- CREATE TABLE `tbl_user` (<br />
`user_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,<br />
`user_name` varchar( 20 ) NOT NULL default '',<br />
`user_password` varchar( 32 ) NOT NULL default '',<br />
`user_regdate` datetime NOT NULL default '0000-00-00 00:00:00',<br />
`user_last_login` datetime NOT NULL default '0000-00-00 00:00:00',<br />
PRIMARY KEY ( `user_id` ) ,<br />
UNIQUE KEY `user_name` ( `user_name` )<br />
) TYPE = MYISAM AUTO_INCREMENT =4;<br />
<br />
MySQL said: Documentation<br />
#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 '-<br />
CREATE TABLE `tbl_user` (<br />
&nbsp; `user_id` int(10) unsigned NOT NULL auto_increme' at line 1
</div>
</div>


Can someone tell me where my error is and how and what to change it to, so I don't have the error?

Error

SQL query:

- CREATE TABLE `tbl_user` (
`user_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`user_name` varchar( 20 ) NOT NULL default '',
`user_password` varchar( 32 ) NOT NULL default '',
`user_regdate` datetime NOT NULL default '0000-00-00 00:00:00',
`user_last_login` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `user_id` ) ,
UNIQUE KEY `user_name` ( `user_name` )
) TYPE = MYISAM AUTO_INCREMENT =4;

MySQL said: Documentation
#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 '-
CREATE TABLE `tbl_user` (
  `user_id` int(10) unsigned NOT NULL auto_increme' at line 1

This looks like a very similar issue to yours (almost the same!), and there was a solution posted.
http://stackoverflow.com/questions/4639788/sql-create-table-error (http://stackoverflow.com/questions/4639788/sql-create-table-error)

I could post what&#39;s inside the link, but in the interest of time, it may be faster for you to check it out.

Error in Creating a table in myphpadmin

Can someone tell me where my error is and how and what to change it to, so I don&#39;t have the error?

Error

SQL query:

- CREATE TABLE `tbl_user` (
`user_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`user_name` varchar( 20 ) NOT NULL default &#39;&#39;,
`user_password` varchar( 32 ) NOT NULL default &#39;&#39;,
`user_regdate` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
`user_last_login` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
PRIMARY KEY ( `user_id` ) ,
UNIQUE KEY `user_name` ( `user_name` )
) TYPE = MYISAM AUTO_INCREMENT =4;

MySQL said: Documentation
#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 &#39;-
CREATE TABLE `tbl_user` (
  `user_id` int(10) unsigned NOT NULL auto_increme&#39; at line 1

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.