List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 30 2001 8:16pm
Subject:Re: help renumbering unique
View as plain text  
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 <mysql-thread84093@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
help renumbering uniqueJaime Teng30 Aug
  • Re: help renumbering uniqueGerald Clark30 Aug
  • RE: help renumbering uniqueCarsten H. Pedersen30 Aug
  • Re: help renumbering uniqueChris Johnson31 Aug