MSSql & MySQL

Hi there,

I am busy converting a MSSql database creation script to a MySQL database creation script.

Everything is going reasonably well except I can't get MySQL to make the following work.

CREATE TABLE tTasksMy (
intTaskID int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
vchTaskDesc text NULL
)

MySQL complains about the IDENTITY (1,1) bit. Anyone have any ideas ?

Thanks

Jmysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT (http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html)|||Thanks ! -- Works like a charm!

Originally posted by r937
mysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT (http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html)sql