MySQL Problem [ High ]
#1

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;");
Reply
#2

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

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


Forum Jump:


Users browsing this thread: 3 Guest(s)