Restart Invoice number in AdminLT template [duplicated]


Download a web system to manage purchases and sales in problem is that the invoices start at 1000 as seen in the reference photo, how can I reset the invoice number to 0? Thanks!

asked by Jose011 31.08.2018 в 08:02

1 answer


To restart the incremental car, you execute:

ALTER TABLE <nombre de tu tabla> AUTO_INCREMENT = 1

The most normal thing is to start with 1 the ids of any table, if you really need to start from 0 you have to use:


Try to use the search engine before asking your question, this has already been answered:

How to restart the auto_increment of MYSQL?

answered by 31.08.2018 / 08:16