Mysql Experts, take a look please.
#10

There are some words that are reserved by MySQL, so doing this:

pawn Код:
mysql_query("UPDATE `accounts` SET Points = '50' ...");
Wouldn't work. Why? The word Points contains a word (int) which is reserved by MySQL.
Therefore, that query won't be executed, and an error will be logged into mysql_log.txt.

Here's the correct way:

pawn Код:
mysql_query("UPDATE `accounts` SET `Points` = '50' ...");
You must include the backtick character before and after a table/field name.
Reply


Messages In This Thread
Mysql Experts, take a look please. - by Ronaldo_raul™ - 16.09.2012, 11:14
Re: Mysql Experts, take a look please. - by Vince - 16.09.2012, 11:19
Re: Mysql Experts, take a look please. - by Ronaldo_raul™ - 16.09.2012, 11:34
Re: Mysql Experts, take a look please. - by Vince - 16.09.2012, 11:47
Re: Mysql Experts, take a look please. - by Ronaldo_raul™ - 16.09.2012, 12:18
Re: Mysql Experts, take a look please. - by Sinner - 16.09.2012, 12:40
Re: Mysql Experts, take a look please. - by Ronaldo_raul™ - 16.09.2012, 18:20
Re: Mysql Experts, take a look please. - by ReneG - 16.09.2012, 19:19
Re: Mysql Experts, take a look please. - by Ronaldo_raul™ - 17.09.2012, 07:10
Re: Mysql Experts, take a look please. - by Emmet_ - 17.09.2012, 07:18

Forum Jump:


Users browsing this thread: 2 Guest(s)