How to set auto_increment for MYSQL

[rocky rambo]

Dear all

i tried to set auto_increment for the primary key "NEWUSERID" for the table
"newuserregistration" using navicat.

Database :MySQL
Database Explorer :Navicat 8 MySQL

but this does not work.

problem:
What i need is whenever user provides all the details for the table "newuserregistration" and clicks on submit a new "NEWUSERID" which acts as a primary key automatically gets filled using the format "A001 ,A002,A003,A004........" and this creates a new record within the table "newuserregistration" represented by the primary key "NEWUSERID".

Steps to reproduce:
1.open navicat
2.open database
3.open table in design view
4.try to provide value to Auto Increment under options tab as 1 or anything.
5.click on save
6.the value you have entered into AutoIncrement gets invisible and nothing is saved.
7.Try to add new record it does not automatically fill the NEWUSERID column value.

Please suggest me any tool/explorer/ or ny idea through which this can be easily achieved.

waiting for ur reply.............



Edited 1 time(s). Last edit at 02/13/2009 02:59PM by rocky rambo.