MySQL Problem [ High ] - Printable Version

MySQL Problem [ High ] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Problem [ High ] (/showthread.php?tid=437837)

MySQL Problem [ High ] - zT KiNgKoNg - 17.05.2013

Hey guys, I'm trying to create a database table if it doesn't exist so far it has been going well BUT when i try and
put ( "`Gender` varchat(5) NULL,"\ ) in it has these errors, Witch for some reason today i can't rap my head around.

Errors.

pawn Код:

C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(135 -- 152) : error 075: input line too long (after substitutions)
C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(153) : warning 215: expression has no effect
C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(153) : error 001: expected token: ";", but found ")"
C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(153) : error 029: invalid expression, assumed zero
C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(153) : error 017: undefined symbol "ENGINE"
C:\Users\A. Rapter\Documents\SAMP [Roleplay] [Scripting]\gamemodes\ug-rp.pwn(153) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


5 Errors.

Table Creation Code.

pawn Код:

mysql_query(
            "CREATE TABLE IF NOT EXISTS `Accounts` ("\
              "`AccID` int(10) NOT NULL AUTO_INCREMENT,"\
              "`Username` varchar(24) NOT NULL,"\
              "`Password` varchar(64) NOT NULL,"\
              "`Email` varchar(64) NOT NULL,"\
              "`IP` varchar(16) NULL,"\
              "`P_X` FLOAT NULL,"\
              "`P_Y` FLOAT NULL,"\
              "`P_Z` FLOAT NULL,"\
              "`StaffLevel` int(15) NULL,"\
              "`HelperLevel` int(15) NULL,"\
              "`DonatorLevel` int(15) NULL,"\
              "`Money` int(15) NULL,"\
              "`Level` int(15) NULL,"\
              "`Age` varchar(64) NULL,"\
              "`Gender` varchat(5) NULL,"\
              "PRIMARY KEY (`AccID`)"\
            ") ENGINE=InnoDB DEFAULT CHARSET=latin1;");

Re: MySQL Problem [ High ] - Vince - 17.05.2013

Do not create a table in code. It is unnecessary. Use an external client to create tables.

Re: MySQL Problem [ High ] - zT KiNgKoNg - 17.05.2013

@Vince - This is for testing so i can add new functions to the table, Any way to resolve this?