How to delete a column from a row inside a table? (mysql)
#4

[ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE `pass`, `salt` FROM `users` WHERE `id` = '1'' at line 1

It's like this now:
pawn Код:
format(query, sizeof (query), "UPDATE `users` DELETE `pass`, `salt` FROM `users` WHERE `id` = '%i'", gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query, false, "", "");
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)