MySQL :: Re: Select and update at the same time (with selected value)?

New Topic

Re: Select and update at the same time (with selected value)?

Posted by: Barry Galbraith
Date: June 28, 2010 11:13PM

Quote

UPDATE ... LAST_UPDATE_ID(id);

I was just going to say that!
UPDATE locks the row it selects so it can write to it, then unlocks it.
That'll stop another server getting the same row.

Good luck,
Barry.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Select and update at the same time (with selected value)?

Kevin K

June 12, 2010 08:52PM

Re: Select and update at the same time (with selected value)?

laptop alias

June 13, 2010 02:15AM

Re: Select and update at the same time (with selected value)?

Rick James

June 13, 2010 11:33AM

Re: Select and update at the same time (with selected value)?

Kevin K

June 17, 2010 08:44PM

Re: Select and update at the same time (with selected value)?

Barry Galbraith

June 17, 2010 09:33PM

Re: Select and update at the same time (with selected value)?

Kevin K

June 28, 2010 12:19AM

Re: Select and update at the same time (with selected value)?

Barry Galbraith

June 28, 2010 03:54PM

Re: Select and update at the same time (with selected value)?

Kevin K

June 28, 2010 09:41PM

Re: Select and update at the same time (with selected value)?

Rick James

June 28, 2010 11:09PM

Re: Select and update at the same time (with selected value)?

Barry Galbraith

June 28, 2010 11:13PM

Re: Select and update at the same time (with selected value)?

Kevin K

June 30, 2010 09:49PM

Re: Select and update at the same time (with selected value)? LAST_INSERT_ID

Rick James

June 30, 2010 11:14PM

Re: Select and update at the same time (with selected value)? LAST_INSERT_ID

Barry Galbraith

June 30, 2010 11:40PM

Re: Select and update at the same time (with selected value)? LAST_INSERT_ID

Rick James

July 01, 2010 10:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.