update record, add statement ?

[Anon]

Hello,

Can anyone tell me how to do the following in MySQL ? :
Can i update a record so that it adds a certain value to the field itself ?

For example : I have the following table:

Name Traffic

John 454545

Can i update this record so that i can ADD a certain value, 43266 for example, to the traffic field ? Some sort of ADD statement for the UPDATE command ?

Regards,
Nick

[brandonschnell]

UPDATE table SET traffic = traffic + 1

[Anon]

Thanks,

Damn i feel stupid now 🙂

Nick