添加前缀以在mysql db中自动增加

Question

I have my database with table test1. It has a primary id "Id" which is auto-increment. Now the id is in the format 1,2,3.. . .Is it possible to store the primary Id as PNR1,PNR2,PNR3 .. . . and so on(with auto-increment).

Answer 1

No. Either add the prefix in the query, or use a view instead.