Hi, I want to know whether au

[stephenraj]

Hi,

I want to know whether auto increment column is supported in MySQL or Not?

For example this is equivalent to IDENTITY column and sequence in case of IBM DB2.

If this is supported in MySQL(either IDENTITY or SEQUENCE, or both) please provide the exact syntax for creating, altering and dropping the sequence.

Please mail me as early as possible.

Regards,
stephen

 

[swampBoogie]

There is an online manual at

http://www.mysql.com

Search for create table.

 

[stephenraj]

Hi,

I found the syntax for auto_increment column while creating the table.

I want to know whether this auto_increment supports properties like INITIAL VALUE, INCREMENT VALUE, etc.. (similar to Cloudscape or IBM DB2)?????????????

This is urgent, pls try to make it soon.

Regards,
Stephenraj