Search code examples
databaseauto-increment

possible to add a letter to an ID but it still autonumbers

I Have database called books.

I want to have the ID's in say books db to be B1, B2 etc and then just keep incrementing the number automatically.

Is this automatically done by the system or would I have to make the ID's myself when inserting anything into the db??

Note I'm using php.

Solution

  • The only type of ID that can be auto-incremented is a number based ID.

    Anything else you would have to put in manually (or hackily in the database which is not recommended)