List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:June 16 1999 2:02pm
Subject:Re: AUTO INCREMENT QUESION
View as plain text  
sneidr rider wrote:
> 
> hi all -
> 
>    i have a table with about 70 rows and 8 cols. i simply want to add a
>    colum that will index each row from 0 or 1 to 69 or 70 (doesnt matter
>    where the index starts)
>    i just dont want to have to create a colum and fill in the rows myself
>    with the numbers. can this be done with a simple command in mysql?
> 

Yes. Look in the manual for ALTER TABLE table ADD COLUMN

  jim...
Thread
AUTO INCREMENT QUESIONsneidr rider16 Jun
  • Re: AUTO INCREMENT QUESIONJim Faucette16 Jun