Re: Multi-column Primary Key

[Dmitry Tolpeko]

Mark,

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
--

http://www.sqlines.com - MySQL Migration Tools