integer identity

[jael]

create table paulhyperlink (id int IDENTITY, title varchar , linkaddress varchar, add_date date, type integer(1))

this sql use in mysql got the error msg:

Error 1064: You have an error in your SQL syntax near 'IDENTITY, title varchar , linkaddress varchar, add_date date, type integer(1))' at line 1

wt's wrong??
can anyone help??

[barand]

IDENTITY added in version 4.0, according to my manual, as alias for auto_increment.

Try auto_increment and see if that works.