Re: help with resequencing...

2001-10-20 Thread Carl Troein
shetie dog writes: > Hi. > This may be a obvious problem but... > I want to re sequence a auto increment column called p_key starting with 1001. Hmm... sounds like bad database design to me, but OK. > I found some information on this the Paul DuBois book MySql: > I tried dropping the column a

help with resequencing...

2001-10-19 Thread shetie dog
Hi. This may be a obvious problem but... I want to re sequence a auto increment column called p_key starting with 1001. I found some information on this the Paul DuBois book MySql: I tried dropping the column and adding it again per there instructions: ALTER TABLE t DROP i; ALTER TABLE t ADD i