Page 1 of 1

database error

Posted: Wed Jan 26, 2005 5:49 am
by dune
CREATE TABLE `crimeper` (

`bankper` varchar(2) NOT NULL DEFAULT `0`
`casinoper` varchar(2) NOT NULL DEFAULT `0`
`bankper` varchar(2) NOT NULL DEFAULT `0`
`ppper` varchar(2) NOT NULL DEFAULT `0`
) TYPE=MyISAM AUTO_INCREMENT=13 ;



Error:

Fout
SQL-query:

CREATE TABLE `crimeper` (

`bankper` varchar( 2 ) NOT NULL DEFAULT `0` `casinoper` varchar( 2 ) NOT NULL DEFAULT `0` `bankper` varchar( 2 ) NOT NULL DEFAULT `0` `ppper` varchar( 2 ) NOT NULL DEFAULT `0`
) TYPE = MYISAM AUTO_INCREMENT =13
MySQL retourneerde:

#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 '0`
`casinoper` varchar(2) NOT NULL DEFAULT `0`
`bankper` varc


what did i wrong
pls help me

Posted: Wed Jan 26, 2005 6:09 am
by timvw
should be '0' instead of `0`