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: 177
mysql
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