Primary key format in mysql

pk, mysql

[ksugam]

Hello All,
I am trying to create a table in mysql with the format of primary key as 'abc-00001'. i want this to be auto-increment field.
We have a function called "format" in Access where we can specify the format of primary key.
Do we have a similar function in mysql?

Thanks!

[coopster]

Some attributes do not apply to all data types.

AUTO_INCREMENT

applies only to integer and floating-point types.

Resource:
[dev.mysql.com...]

However, you can create a compound key. More information here ...
[dev.mysql.com...]