PDA

View Full Version : mysql syntax


rocketbunny
09/07/2019, 02:33 PM
[21:20:23] [plugins/mysql] error #1064 while executing query "INSERT INTO `Skin` = '20001' FROM `accounts` WHERE `pUsername` = 'rocketBunny' "
new query[300];
mysql_format(db, query, sizeof(query), "INSERT INTO `Skin` = '%i' FROM `accounts` WHERE `pUsername` = '%e'", PlayerInfo[playerid][pSkin], GetName(playerid));
mysql_tquery(db, query);

Robson04
09/07/2019, 02:49 PM
mysql_format(db, query, sizeof(query), "INSERT INTO accounts SET Skin = '%i' WHERE pUsername = '%s'", PlayerInfo[playerid][pSkin], GetName(playerid));
mysql_tquery(db, query);

Robson04
09/07/2019, 02:51 PM
Advice for you. Use small leters on your table data. You can will remember the letters in a row.

rocketbunny
09/07/2019, 03:45 PM
Advice for you. Use small leters on your table data. You can will remember the letters in a row.
thank u