MySQL Forums
Forum List  »  Newbie

Re: How to add a prefix to a auto increment field
Posted by: Mark Snyder
Date: April 08, 2010 06:37AM

Are you really sure you want to? Then you would lose the ability to select and ORDER BY that field.

If you really want to you should do it at the application (e.g. PHP) level.

I suggest you really think about this. And use the CONCAT function NR described.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to add a prefix to a auto increment field
April 08, 2010 06:37AM


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.