Leading auto increment value

[tyson.crouch]

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.

[pritaeas]

ALTER TABLE tablename AUTO_INCREMENT = 201200001

[tyson.crouch]

Thank you !