Hi,
I have a mysql table:
+-----------+------------------+------+-----+
| Field | Type | Null | Key |
+-----------+------------------+------+-----+
| sessionid | int(10) unsigned | | PRI |
| username | char(20) | | MUL |
| start | int(10) unsigned | | MUL |
| stop | int(10) unsigned | | MUL |
| ipaddress | char(15) | YES | |
+-----------+------------------+------+-----+
sessionid is a unique key.
Is there a way to change the values of sessionid such that
the values will be numbered from 1 and increments by 1?
ie, if the numbers were "1,20,22,25,40,45,47....."
the new data will be "1,2,3,4,5,6,7,8,9....." ?
Jaime
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
