MySQL - INSERT INTO - Printable Version

MySQL - INSERT INTO - 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 - INSERT INTO (/showthread.php?tid=406429)

MySQL - INSERT INTO - Rdx - 10.01.2013

Okay, delete topic.

Re: MySQL - INSERT INTO - Fabio11 - 10.01.2013

Why dont you split it? I mean like

pawn Код:

new query[2][1024];
format(query[0], sizeof(query[0]), "INTERT INTO ... %s %s %s...", variable, variable, variable);
format(query[1], sizeof(query[1]), "%s .. continue writing %s %s", query[0], variable, variable);
// Not tested, so I don't know if it works or not.

Edit: For INSERT INTO you must use this syntax:

PHP код:



INSERT INTO table_name (column1, column2, column3,...)

VALUES (value1, value2, value3,...)

Your actual syntax is for UPDATE.

Look here: http://www.w3schools.com/sql/sql_insert.asp