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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.