Want I want to do is create a table with a primary key that
will increment numbers with a letter code before it.
For example FG01
Is it possible to do this with mysql, I undertand that the primary key value is usually a integer so it might not be possible to do this.But I have seen it done on other sites so it must be possible.
Could anyone help.