[thelist] Auto Increment in database

[NanHarbisonSmith at aol.com]

--
[ Picked text/plain from multipart/alternative ]
 jay.blanchard at niicommunications.com writes:

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



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

Nan Harbison Smith