Re: who knows the difference between INSERT and UPDATE

2009-12-06 Thread mos
At 12:13 AM 12/6/2009, Oscar wrote: hi all, Someone told me that UPDATE equals DELETE old row + INSERT new row. Anybody clarify it? Are you talking about InnoDb or MyISAM tables. I'm only familiar with MyISAM tables. Perhaps he was referring to an Update that added more text to a variable

who knows the difference between INSERT and UPDATE

2009-12-05 Thread Oscar
hi all, Someone told me that UPDATE equals DELETE old row + INSERT new row. Anybody clarify it? thanks, -Oscar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org