Is there a way that a column in MYSQL table generate a formatted UID?

Asked Apr 18 '16 at 17:18

Active Apr 18 '16 at 17:18

Viewed 177 times

Is there a way that a column in MYSQL table generate a formatted UID like :

DNR00001/16 DNR00002/16 DNR00003/16

Where :

'DNR' a varchar

'00001' is the varchar(5) of the auto-incremented id

'/' is a separator

'16' is the year

I got inspired by this topic

Thanks

edited May 23 '17 at 12:17

Community

asked Apr 18 '16 at 17:18

You could use a trigger to build that for you, but you can't have a non-numeric auto-generated ID like that, the way a normal auto_increment works. – Marc B Apr 18 '16 at 17:22
i know about triggers and auto-incremented ID but are not options on my case – Mohammed Housseyn Taleb Apr 18 '16 at 17:24
What's your plan for the hundred thousandth record? – Dan Bracuk Apr 18 '16 at 17:27
i will reset the auto increment because in one year i have about 10000 entry in the population then i must restart from 0 in the next year – Mohammed Housseyn Taleb Apr 18 '16 at 17:30
and also i m using another primary key unlimited this is only a secondary key for clients – Mohammed Housseyn Taleb Apr 18 '16 at 17:31
and i have only one subscribe for one client in all his life – Mohammed Housseyn Taleb Apr 18 '16 at 17:32

0 Answers0