Re: mysql: edit mutliple forms with one submit button

It's worth noting that MySQL will optimize UPDATEs so that it won't update a field to a value that's already stored in that field... UPDATE table SET name="John Smith" WHERE id=1 will turn into a no-op if name is already set to "John Smith".

Unless your user list is very very long it might be a good idea to just update every field for every record every time "submit" is pressed. I suspect the performance impact will be minimal, and you don't have to mess with JavaScript or anything hinky like that.

Gary Blackburn
Trained Killer

Comment on Re: mysql: edit mutliple forms with one submit button

Replies are listed 'Best First'.
Re: Re: mysql: edit mutliple forms with one submit button by Arien (Pilgrim) on Jan 12, 2003 at 08:26 UTC
`UPDATE table SET name="John Smith" WHERE id=1` will turn into a no-op if name is already set to `"John Smith"`. For very flexible values of no-op. — Arien	[reply]