On May 15, 2008, at 1:38 PM, afan pasalic wrote:
hi,
I have a table with tasks. column "status" could be 1 (means "todo")
and
0 (meas "done").
also,have column "order_no" to sort tasks by priorities.
once in a while order_no is not "in order", e.g 1, 2, 3, 5, 6, 8, 11,
12, 13, 19, 20,... (some numbers are missing).
is there built in function to "reset" order_no or I have to create php
script for it?
Why do you care if there are gaps? Do they really matter?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
