Saving problem (MySql)
#1

Hi,

I had problem with saving system, and I'm try to add in my database INSTER INTO, etc...
But, I get this error:
PHP код:
--
-- 
Dumping data for table `accounts`
--
INSERT INTO  `accounts` (  `Name` ,  `Password` ,  `IP` ,  `RegStr` ,  `AdminLevel` ,  `VIPLevel` ,  `XP` ,  `Money` ,  `Banked` ,  `Kills` ,  `Deaths` , `Captures` ,  `wBought` ,  `wBought` ,  `Hours` ,  `Minutes` ,  `Seconds` ,  `LastPlayed` ) 
VALUES -- --------------------------------------------------------
--
-- 
Tabelstructuur voor tabel `bans`
--
CREATE TABLE IF NOT EXISTS  `bans` (
 `
BanIDINTNOT NULL ,
 `
NameVARCHAR24 NOT NULL ,
 `
AdminVARCHAR24 NOT NULL ,
 `
ReasonVARCHAR128 NOT NULL ,
 `
IPVARCHAR16 NOT NULL ,
 `
DateVARCHAR32 NOT NULL
ENGINE INNODB DEFAULT CHARSET latin1;
MySQL saysDocumentation
#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 `bans` (
  
`BanIDint(6NOT NULL,
  `
Namevarcha' at line 20 
Thanks.
Reply


Messages In This Thread
Saving problem (MySql) - by ZaBraNjeNi - 12.02.2015, 09:12
Re: Saving problem (MySql) - by Misiur - 12.02.2015, 13:00
Re: Saving problem (MySql) - by asto63 - 12.02.2015, 14:10
Re: Saving problem (MySql) - by ZaBraNjeNi - 12.02.2015, 20:16

Forum Jump:


Users browsing this thread: 1 Guest(s)