how to add prefix in auto incremanet field in mysql?
- by I Like PHP
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??