Re: Making up for lack of subqueries (-or- "what the heck am I doing?")

[Brent Baisley]

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, 2002, at 12:43 PM, Zeno wrote:

I have found this to be _infinitely_ faster than
taking each article number, doing a SELECT to see if it is in the main
table, and an INSERT if it is not (we're talkin' light years faster).

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


---------------------------------------------------------------------
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