RE: Does MySQl support Identity key?

[Michael Widenius]

>>>>> "Jay" == Jay Miller <jaymiller@stripped> writes:

Jay> IDENTITY is AUTO_INCREMENT
Jay> CREATE TABLE SystemVer(ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID),Name
Jay> varchar(10) NOT NULL, Details varchar(100));

It would be easy to add AUTO_INCREMENT as a synonym for IDENTITY,
but this would be make IDENTITY a restricted word...

Thanks for the update.

Regards,
Monty