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!
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!
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:
SET [GLOBAL|SESSION] sql_mode='NO_AUTO_VALUE_ON_ZERO'
Try to use the search engine before asking your question, this has already been answered: