Zeno 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.
It may seem strang
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
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.
On Thursday, December 19
Couldn't figure out what the option "FOR UPDATE" does in a SELECT
statement unless it's just to lock the table. Spent the last few
hours trying to get subqueries to work only to find that the reason
they're not working is not just due to my abominable syntax.
What I'm doing is getting messages fr