Jump to content

[SOLVED] Create Table query error


MasterACE14

Recommended Posts

Hi Guys,

 

I am trying to create a table in PHPMyAdmin, I've created 4 other tables in this database the same way and they all worked. But this query I'm trying to run doesn't want to work, and I have no idea why?

 

Any help is greatly appreciated.

 

Error

 

SQL query:

 

CREATE TABLE `rf_users` (

`id` int( 100 ) unsigned NOT NULL AUTO_INCREMENT ,

`username` varchar( 50 ) NOT NULL default '',

`password` varchar( 50 ) NOT NULL default '',

`email` varchar( 100 ) NOT NULL default '',

`regdate` datetime NOT NULL default '0000-00-00 00:00:00',

`onlinetime` datetime NOT NULL default '0000-00-00 00:00:00',

`authlevel` int( 10 ) unsigned NOT NULL default '0',

`postcount` int( 100 ) unsigned NOT NULL default '0' PRIMARY KEY ( `id` )

) TYPE = MYISAM

 

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 '(`id`)

) TYPE=MyISAM' at line 10

 

Regards ACE

 

EDIT: after 2 hours, I finally got it. So simple too :S needed a comma after default '0' in post count.

 

Link to comment
https://forums.phpfreaks.com/topic/117499-solved-create-table-query-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.