I have a table with an autoincrement primary key, and a I hold list of the
keys of a number of records which I want to UPDATE. How can I most
efficiently write an UPDATE command which will update all the record whose
keys are on my list?
I thought I could put the keys I have into a temporary ram table and use
some sort of SELECT like statement to join the temporary table to the real
one, but I can't see any syntax for it. Is there no way to so it other than
to issue an individual update for every record?
Alec Cawley
<<--
This e-mail is intended for the named addressees only. Its contents may be
privileged or confidential and should be treated as such. If you are not
an intended recipient please notify the sender immediately; do not copy,
distribute, or take any action based on this e-mail; and then delete it.
In the pursuit of its legitimate business activities and its conformance
with relevant legislation, Quantel Ltd. may access any e-mail (including
attachments) it originates and receives, for potential scrutiny.
To learn more about Quantel's Clipbox Studio, go to
http://www.quantel.com/clipboxstudio
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
