Problema mysql

[dandrew12]

Salut, nu stiu daca postez unde trebuie dar am o probelma cand dau import imi arata asta:

[pawn]SQL query:

-- --------------------------------------------------------

--

-- Structura de tabel pentru tabelul `bizz`

--

DROP TABLE IF NOT EXISTS `bizz` (

  `ID` int(11) NOT NULL AUTO_INCREMENT,

  `Owned` int(11) NOT NULL,

  `Owner` varchar(25) NOT NULL DEFAULT 'The State',

  `Message` varchar(50) NOT NULL,

  `EntranceX` float NOT NULL,

  `EntranceY` float NOT NULL,

  `EntranceZ` float NOT NULL,

  `ExitX` float NOT NULL,

  `ExitY` float NOT NULL,

  `ExitZ` float NOT NULL,

  `LevelNeeded` int(11) NOT NULL,

  `BuyPrice` int(11) NOT NULL,

  `EntranceCost` int(11) NOT NULL,

  `Till` int(11) NOT NULL,

  `Locked` int(11) NOT NULL,

  `Interior` int(11) NOT NULL,

  `Products` int(11) NOT NULL,

  `MaxProducts` int(11) NOT NULL,

  `PriceProd` int(11) NOT NULL,

  `Virtual` int(11) NOT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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 'NOT EXISTS `bizz` (

  `ID` int(11) NOT NULL AUTO_INCREMENT,

  `Owned` int(11) NO' at line 6 [/pawn]

[[ESS]Skull]

Nu am mai vazut niciodata pana acum:

DROP TABLE IF NOT EXISTS 

Vroiai sa scrii cumva

CREATE TABLE IF NOT EXISTS `bizz`

?

[dandrew12]

Tot la fel, am pus drop pt ca vazusem undeva si credeam ca este bine ...

[[ESS]Skull]

Tot la fel, am pus drop pt ca vazusem undeva si credeam ca este bine ...

Incearca:

CREATE TABLE IF NOT EXISTS `bizz` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Owned` int(11) NOT NULL, `Owner` varchar(25) NOT NULL DEFAULT '0', `Message` varchar(50) NOT NULL, `EntranceX` float NOT NULL, `EntranceY` float NOT NULL, `EntranceZ` float NOT NULL, `ExitX` float NOT NULL, `ExitY` float NOT NULL, `ExitZ` float NOT NULL, `LevelNeeded` int(11) NOT NULL, `BuyPrice` int(11) NOT NULL, `EntranceCost` int(11) NOT NULL, `Till` int(11) NOT NULL, `Locked` int(11) NOT NULL, `Interior` int(11) NOT NULL, `Products` int(11) NOT NULL, `MaxProducts` int(11) NOT NULL, `PriceProd` int(11) NOT NULL, `Virtual` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9

Cel putin la mine a mers.

[scoverga]

dandrew12, DROP = şterge. Nu mai copia orbeşte în viitor fără să ştii ce copiezi.