On Thu, 19 Dec 2002 15:50:18 -0500, Brent Baisley wrote: Thanks, Brent. I did read about the REPLACE command, but I only want to change one field (a simple flag) in the main_table. With REPLACE, I cannot even copy the rest of the fields into the new record because it does not offer any access to the existing fields.
Thanks again, - Zeno >Have you tried looking into the REPLACE command? It basically does an >update if the record is present or an insert if it's not, but all in one >command. Since MySQL won't update a record if you are trying to update >it with data that is unchanged it should be pretty fast. --------------------------------------------------------------------- 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
