[SOLVED] Sql not working for poker.

[skippa]

This Is The Message I Get

 

 

MySQL said: 

 

#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 '' at line 35

 

 

When I Try To Upload

 

CREATE TABLE `poker` (

  `id` int(11) NOT NULL auto_increment,

  `player1` varchar(40) NOT NULL default '',

  `player2` varchar(40) default NULL,

  `player3` varchar(40) default NULL,

  `player4` varchar(40) default NULL,

  `cards1` varchar(250) default NULL,

  `cards2` varchar(250) default NULL,

  `cards3` varchar(250) default NULL,

  `cards4` varchar(250) default NULL,

  `money1` int(11) default '0',

  `money2` int(11) default '0',

  `money3` int(11) default '0',

  `money4` int(11) default '0',

  `deck` varchar(250) NOT NULL default '',

  `ante` int(16) NOT NULL default '0',

  `pot` int(16) NOT NULL default '0',

  `password` varchar(32) default NULL,

  `current` varchar(40) default NULL,

  `stage` int(1) default '0',

  `swapstart` int(1) NOT NULL default '0',

  `raiseamount` int(11) NOT NULL default '0',

  `currentraise` int(1) NOT NULL default '0',

  `maxraise` int(16) default NULL,

  `allin` binary(1) NOT NULL default '0',

  `lastmove` int(11) default NULL,

  `winners` varchar(250) NOT NULL default '',

  `created` int(11) NOT NULL default '0',

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

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

  `p3` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

  `p4` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

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

  PRIMARY KEY  (`id`),

  UNIQUE KEY `player1` (`player1`,`player2`,`player3`,`player4`)

 

 

Can anyone help please, much appreciated.

[gnawz]

Start with putting a semi colon at the end of the SQL statement

[skippa]

`id` int(11) NOT NULL auto_increment' at line 1

 

 

This is what i get when i do that

 

 

[Mchl]

You have missing ) at the very end.

 

CREATE TABLE `poker` (
  `id` int(11) NOT NULL auto_increment,
  `player1` varchar(40) NOT NULL default '',
  `player2` varchar(40) default NULL,
  `player3` varchar(40) default NULL,
  `player4` varchar(40) default NULL,
  `cards1` varchar(250) default NULL,
  `cards2` varchar(250) default NULL,
  `cards3` varchar(250) default NULL,
  `cards4` varchar(250) default NULL,
  `money1` int(11) default '0',
  `money2` int(11) default '0',
  `money3` int(11) default '0',
  `money4` int(11) default '0',
  `deck` varchar(250) NOT NULL default '',
  `ante` int(16) NOT NULL default '0',
  `pot` int(16) NOT NULL default '0',
  `password` varchar(32) default NULL,
  `current` varchar(40) default NULL,
  `stage` int(1) default '0',
  `swapstart` int(1) NOT NULL default '0',
  `raiseamount` int(11) NOT NULL default '0',
  `currentraise` int(1) NOT NULL default '0',
  `maxraise` int(16) default NULL,
  `allin` binary(1) NOT NULL default '0',
  `lastmove` int(11) default NULL,
  `winners` varchar(250) NOT NULL default '',
  `created` int(11) NOT NULL default '0',
  `p1` varchar(100) NOT NULL default '',
  `p2` varchar(100) NOT NULL default '',
  `p3` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',
  `p4` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',
  `entry` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `player1` (`player1`,`player2`,`player3`,`player4`));

 

[skippa]

lol im such a noob lol, thanks Mchl