Re: How to set auto_increment for MYSQL
Posted by:
Rick James
Date: February 18, 2009 12:46AM
Well... auto_increment cannot have the form A001. But you could have a column with the INT AUTO_INCREMENT, then somehow concatenate 'A' and the value of the auto_increment. Perhaps something like...
CONCAT('A', LPAD(id, 3, '0')) AS NEWUSERID
Subject
Written By
Posted
February 13, 2009 02:34PM
Re: How to set auto_increment for MYSQL
February 18, 2009 12:46AM
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.