[thelist] Auto Increment in database

[Jay Blanchard]

[snip]
> >The option offered by Anthony Baratta, "With MS SQL, I've just dropped
the
> >D Field saved the changes, then added
> >the ID Field back in."
> >...worked...and does save time...especially over dropping the whole
shebang

I just tried doing this in MySQL, dropping the ID field and then reinserting
it, and PHPmyAdmin keeps giving me this error message:

> ySQL said:
> Incorrect table definition; There can only be one auto column and it must
> be defined as a key
> Does this only work in MS SQL?
[/snip]

I was able to do it in the MySQL monitor from the command line. I haven't
done one of the big tables, but I have done two small tables.

Jay