Hey Guys,

I've got a question that's gotten me stumped.
Granted, i've been away from MySQL and daniweb for well over 18months, i've picked up pretty much where i left off back then, and am just filling in the blanks as i go along.

My question is:
i have a primary key (auto increment) that i want to set as the following format: 2012xxxxx.

so i have a leading value of 2012, and subsequently 5 trailing values (which are to be auto incremented).

To be honest, im not sure if it can be done or not, but im just hoping (as im going to use the values to produce barcodes for customer files later down the track).

Any help would be appreciated.

5 Years
Discussion Span
Last Post by tyson.crouch
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.