CREATE TABLE statement errors - Printable Version

CREATE TABLE statement errors - 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: CREATE TABLE statement errors (/showthread.php?tid=571496)

CREATE TABLE statement errors - Denis1 - 19.04.2015

I know it's not worth the effort to create tables via PAWN, but I've only done it to get used to SQL statements. However, even though I'm using the correct syntax, I'm getting some errors.

Код:

	
	mysql_query(db, "CREATE TABLE IF NOT EXISTS `Houses` (
	`hdbID` INT(20) AUTO_INCREMENT,
	`hOwner` VARCHAR(25) NOT NULL,
	`hPrice` INT(20) NOT NULL,
	PRIMARY KEY(`hdbID`)
	) ENGINE = InnoDB DEFAULT CHARSET=latin1");

The size of the int data types are totally random.

Compiler errors:

Quote:

E:\SA-MP server\gamemodes\house.inc(56) : error 037: invalid string (possibly non-terminated string)
E:\SA-MP server\gamemodes\house.inc(57) : warning 217: loose indentation
E:\SA-MP server\gamemodes\house.inc(57) : error 029: invalid expression, assumed zero
E:\SA-MP server\gamemodes\house.inc(57) : warning 215: expression has no effect
E:\SA-MP server\gamemodes\house.inc(57) : error 001: expected token: ";", but found "`"
E:\SA-MP server\gamemodes\house.inc(57) : error 029: invalid expression, assumed zero
E:\SA-MP server\gamemodes\house.inc(57) : fatal error 107: too many error messages on one line

Thanks!

Re: CREATE TABLE statement errors - J4Rr3x - 19.04.2015

You need to add backslash at the end of the line for a new line.

pawn Код:

mysql_query(db, "CREATE TABLE IF NOT EXISTS `Houses` ( \
        `hdbID` INT(20) AUTO_INCREMENT, \ 
        `hOwner` VARCHAR(25) NOT NULL, \
        `hPrice` INT(20) NOT NULL, \
        PRIMARY KEY(`hdbID`) \
        ) ENGINE = InnoDB DEFAULT CHARSET=latin1
    ");

Re: CREATE TABLE statement errors - Denis1 - 19.04.2015

It works! Thank you so much.