MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Multi-column Primary Key
Posted by: Dmitry Tolpeko
Date: February 20, 2013 03:42AM


You shouldn't rely on the order of rows returned by SELECT. It may work well on a dozen of rows, but eventually will fail on a large set, and after rows are deleted, updated etc.

In your scenario, I would suggest that you create a primary key on one column SEQNO, and include ORDER BY seqno to SELECT

  SELECT * FROM tab ORDER BY seqno

Dmitry Tolpeko
-- - MySQL Migration Tools

Options: ReplyQuote

Written By
February 06, 2013 03:18PM
Re: Multi-column Primary Key
February 20, 2013 03:42AM

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.