如何在php中添加自动增量主键

I have my database with table test. 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 A1,A2,A3 .. . . and so on(with auto-increment).

You can fetch that id in A1,A2,A3

 SELECT concat('A',id) FROM table_name;

You cant create that of primary key format in mysql