MySQL Forums
Forum List  »  Newbie

How to set auto_increment for MYSQL
Posted by: rocky rambo
Date: February 13, 2009 02:34PM

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.

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: navicat database table in design view
4.try to provide value to Auto Increment under options tab as 1 or anything. 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.

Options: ReplyQuote

Written By
How to set auto_increment for MYSQL
February 13, 2009 02:34PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.