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
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