I would like more comments regarding the REPLACE versus UPDATE command Is Update really better at handing locking issues ?
S On Tue, Apr 24, 2012 at 9:08 PM, AndyD <[email protected]> wrote: > I have found the SQL commands better at handling contention issues, why not: > lDate = date() > UPDATE YourTableName SET post_date = lDate WHERE post_date <> lDate > > AndyD 8-)₹ > > On 23/04/2012 22:57, MB Software Solutions, LLC wrote: >> <snip> >> >> Not sure. My only advice is to change it to this: >> >> REPLACE post_date WITH date() FOR post_date<> date() ALL in YourTableName >> >> Also, if that replacement is happening in the Payment table, why would >> you want to open it with NOUPDATE? >> >> hth, >> --Mike >> >> > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cag1nny-4h328k9xles8ea0p+gg2nk87+w03uoehbbxradmc...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
