Does anyone know how to enable auto_increment on PHPmyAdmin? I’ve done a lot of websearching and found no results. In my table, I have a field “id” that is a primary key, and I’d like to turn it to auto_increment so that it’ll just fill in th next value. Anyone have any ideas?
- Select the table you want to change.
- Click the pencil icon (change) for the field you want to add the auto-increment to.
- Select “auto_increment” from the drop down menu in the “Extra” column.
Use these instructions at your own risk. You may wish to backup your database before fooling around with it.