database error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dune
Forum Newbie
Posts: 1
Joined: Wed Jan 26, 2005 3:59 am

database error

Post 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
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

should be '0' instead of `0`
Post Reply