How can I set my auto-increment value to start from 1 in MySQL?

Question

I have a product table. It had 1000+ products. I deleted all the products. Now, when I add any product, the product_id starts from above 1000. Is there any method to reset it to 1? I'm new to programming and databases. Any sort of help will be much appreciated.

For your farther help, refer below link – Gaurav Lad Nov 02 '15 at 07:51 — Gaurav Lad, Nov 02 '15 at 07:51

score 2 · Accepted Answer · answered Nov 02 '15 at 07:48

2

You could run the truncate table command

TRUNCATE TABLE table_name;

answered Nov 02 '15 at 07:48

chrisShick

1,096
8
21

1

http://stackoverflow.com/questions/20559893/comparison-of-truncate-vs-delete-in-mysql-sqlserver – Gaurav Lad Nov 02 '15 at 07:48

score 2 · Answer 2 · answered Nov 02 '15 at 07:53

2

simply do as per images given hope this will work for you

answered Nov 02 '15 at 07:53

PRANAV

629
4
13

score 1 · Answer 3 · answered Nov 02 '15 at 07:45

1

Okay I found it. It is in auto_increment field in operations.

answered Nov 02 '15 at 07:45

Ali Zia

3,825
5
29
77

How can I set my auto-increment value to start from 1 in MySQL?

3 Answers3