how to add prefix in auto incremanet field in mysql?

Posted by I Like PHP on Stack Overflow See other posts from Stack Overflow or by I Like PHP
Published on 2010-05-24T06:39:22Z Indexed on 2010/05/24 6:41 UTC
Read the original article Hit count: 178

Filed under:

hello All, i just want to know that can we add a prefix to auto increment field of a table in mysql? like my auto increment field of tbl_user is user_id( auto increment). i want this shoud be comes in below way

user_id( auto incremant field)
user1
user2
user3
user4
user5

please suggest me to do this thing by anothey way if it is not possible with auto increment field in mysql??

© Stack Overflow or respective owner

Related posts about mysql