On Mon, 24 Mar 2003 15:17:09 -0500, Keith C. Ivey wrote: >You should definitely keep IDs and order as separate columns, since >you don't want to have to change IDs if the order changes. You might >consider representing the order with a nonconsecutive series of >integers -- for example, leave gaps of 100 between them. That way >you can add a new customer with a delivery order of 350 between the >existing customers with delivery orders of 300 and 400.
That was the only other idea I could come up with and it would certainly work in my context (a small private thing) but it would be unwieldy if the database changed often so I thought there might be some better idea. Rather than start it off inefficiently, I wanted to "do it right". Oh well. On the up side, I'm not as imagination-challenged as I thought--if no one else can think of a better idea either. :-) -- Trevor Smith | [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
