[HELP]MySQL error
#1

Hi,i'm new in MySQL,i am using WAMP,phpMyAdmin gives me error.
Код:
SQL query:

USE `sampnights` CREATE TABLE IF NOT EXISTS `hesaplar` (
`Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`Isim` VARCHAR( 50 ) COLLATE latin1_general_ci NOT NULL ,
`Sifre_Hash` INT( 11 ) NOT NULL ,
`Kayitli` INT( 11 ) NOT NULL ,
`SonGiris` INT( 11 ) NOT NULL ,
`Para` INT( 11 ) NOT NULL ,
`Oldurme` INT( 11 ) NOT NULL ,
`Olum` INT( 11 ) NOT NULL ,
`Saat` INT( 11 ) NOT NULL ,
`Dakika` INT( 11 ) NOT NULL ,
`Saniye` INT( 11 ) NOT NULL ,
`AdminLevel` INT( 11 ) NOT NULL ,
`OyunSure` INT( 11 ) NOT NULL ,
`Skor` INT( 11 ) NOT NULL ,
`Orgut` INT( 11 ) NOT NULL ,
`Lider` INT( 11 ) NOT NULL ,
`Rutbe` INT( 11 ) NOT NULL ,
`EskiOldurme` INT( 11 ) NOT NULL ,
`EskiOlum` INT( 11 ) NOT NULLT,
`Aranma` INT( 11 ) NOT NULL ,
`Bankapara` INT( 11 ) NOT NULL ,
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =1;

MySQL output:
#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 IF NOT EXISTS `hesaplar` (`Id` INT(11) NOT NULL AUTO_INCREMENT,`Isi' at line 1
It's my ".sql" file :
Код:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
use `sampnights`
CREATE TABLE IF NOT EXISTS `hesaplar` 
(
`Id` INT(11) NOT NULL AUTO_INCREMENT,
`Isim` VARCHAR(50) COLLATE latin1_general_ci NOT NULL,
`Sifre_Hash` INT(11) NOT NULL,
`Kayitli` INT(11) NOT NULL,
`SonGiris` INT(11) NOT NULL,
`Para` INT(11) NOT NULL,
`Oldurme` INT(11) NOT NULL,
`Olum` INT(11) NOT NULL,
`Saat` INT(11) NOT NULL,
`Dakika` INT(11) NOT NULL,
`Saniye` INT(11) NOT NULL,
`AdminLevel` INT(11) NOT NULL,
`OyunSure` INT(11) NOT NULL,
`Skor` INT(11) NOT NULL,
`Orgut` INT(11) NOT NULL,
`Lider` INT(11) NOT NULL,
`Rutbe` INT(11) NOT NULL,
`EskiOldurme` INT(11) NOT NULL,
`EskiOlum` INT(11) NOT NULLT,
`Aranma` INT(11) NOT NULL,
`Bankapara` INT(11) NOT NULL,
)ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1;
Reply


Messages In This Thread
[HELP]MySQL error - by Nightmare[TR] - 09.07.2010, 18:42
Re: [HELP]MySQL error - by DJBluefader - 09.07.2010, 18:45
Re: [HELP]MySQL error - by Nightmare[TR] - 09.07.2010, 18:53
Re: [HELP]MySQL error - by DJBluefader - 09.07.2010, 19:05
Re: [HELP]MySQL error - by Nightmare[TR] - 09.07.2010, 19:16
Re: [HELP]MySQL error - by DJBluefader - 09.07.2010, 19:26
Re: [HELP]MySQL error - by WackoX - 09.07.2010, 19:28
Re: [HELP]MySQL error - by DJBluefader - 09.07.2010, 19:30
Re: [HELP]MySQL error - by Nightmare[TR] - 09.07.2010, 19:40

Forum Jump:


Users browsing this thread: 1 Guest(s)