How to set auto_increment for MYSQL
i tried to set auto_increment for the primary key "NEWUSERID" for the table
"newuserregistration" using navicat.
Database Explorer :Navicat 8 MySQL
but this does not work.
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"
Please suggest me any tool/explorer/ or ny idea through which this can be easily achieved.
waiting for ur reply.............:)