How to? BIG SQL UPDATE query?
#5

Quote:
Originally Posted by Emmet_
Посмотреть сообщение
Split it up.

Example:
pawn Код:
new query[152];
format(query, sizeof(query), "UPDATE `table` SET `field1` = 'value', `field2` = 'value', `field3` = 'value', `field4` = 'value', `field5` = 'value', `field6` = 'value' WHERE `blah` = 'blah'");
mysql_query(query);

format(query, sizeof(query), "UPDATE `table` SET...");
mysql_query(query);
Yeah, that's probably the way to go Thanks!
Reply


Messages In This Thread
How to? BIG SQL UPDATE query? - by 13th - 06.11.2012, 23:20
Re: How to? BIG SQL UPDATE query? - by steki. - 06.11.2012, 23:22
Re: How to? BIG SQL UPDATE query? - by 13th - 06.11.2012, 23:25
Re: How to? BIG SQL UPDATE query? - by Emmet_ - 06.11.2012, 23:43
Re: How to? BIG SQL UPDATE query? - by 13th - 07.11.2012, 10:45

Forum Jump:


Users browsing this thread: 1 Guest(s)