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?