How to Reset Auto_Increment in phpMyAdmin

 How to reset auto_increment in a database table if all the data is deleted and you want to fill it in again but want the auto_increment sequence to start from the beginning.

1. Activate the webserver (Apache and MySQL), open a browser, type http://localhost/phpmyadmin

2. Select the database whose auto_increment you want to reset. Then, if there is still data, please delete all the data first. For example, the image below. Adjust the database name and table name to suit yours.

3. Ketikan perintah alter table nama_tabel_anda auto_increment=0;
4. Kemudian klik tombol Go di kanan bawah.

Post a Comment