MySQL Forums
Forum List  »  PHP

Re: Duplicate values being created
Posted by: Peter Brawley
Date: January 25, 2018 03:43PM

> how could SELECT display_order FROM ext_images WHERE parentId = XX
> ORDER BY display_order DESC LIMIT 1 return 2?

I can think of two ways off the top, there are (i) other parentids (ii) concurrency issues. IAC what the db will do isn't limited to what we can think of. You need logic to make dupes impossible.

Options: ReplyQuote

Written By
Re: Duplicate values being created
January 25, 2018 03:43PM

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.