On 24 Mar 2003 at 13:08, Trevor Smith wrote: > I want to create a table of customers on a delivery route. I want to > include the order of delivery in the table. Creating a column with a > sequential id # would be very cumbersome because in the future some new > customers may subscribe -- and these new customers may need to be > inserted into the delivery order.
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. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
