[Woka]

Hi
I'm using G-sTyLeZzZ plugin (MySQL Plugin R2)
There is no function to update a field in SQL server.
So how can i update a value ?
Of course don't suggest using SQL programming such as (Update <Table> SET <Field> = <Value> WHERE <Condition>) because i have to update much data in period of time 30 sec and it make server laggy.
What should i do !?

[Woka]

Bump!!!

[darkrider366]

Try using the MODIFY command. I think..., or just use insert, or delete then insert..

[Woka]

Quote:

Originally Posted by darkrider366 Try using the MODIFY command. I think..., or just use insert, or delete then insert..

If i do delete and insert then it will be more laggy because i send 2 command.
anyway what is MODIFY ?

[Woet]

Nothing is wrong with UPDATE, it's the only and fastest way.
You can set multiple fields though: UPDATE table SET foo = 'bar', bar = 'foo' WHERE 1 = 1

[Daren_Jacobson]

mysql_query("UPDATE `table` SET (`name` = 'Bob', `key` = md5('lolcatkingtheownerofalltheworld')) WHERE `id` = 1

if he made a function it would be even slower.