How can I reset my auto increment column in MYSQL

Question

Hi,

I am facing a problem to reset my auto incremented column.

Can you help me out with this ?

Thanks

Answer 1

Hi Pratim,

I understand your issue.

I think you can try this with this code snippet.

ALTER TABLE `users` AUTO_INCREMENT = 1;

Thanks

I hope it will help you out.