That seems like rather a bad idea to me.
Would that not leave anything else that references the sessions
looking at the wrong session?
Jaime Teng wrote:
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
