[Problem]Who is good with SQL ?
#1

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 !?
Reply
#2

Bump!!!
Reply
#3

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

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 ?
Reply
#5

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
Reply
#6

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

if he made a function it would be even slower.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)