Fastest Web Hosting

how to reset autoincrement in mysql

0 votes
asked Aug 29, 2016 in Mysql by rohit (2,750 points)

i have a code which is using by me for reset AUTO_INCREMENT in MySQL.
That code is

SET  @num := 0;

ALTER TABLE your_table AUTO_INCREMENT =1;

But this is not working.give me solution Immediately please.
Thanks

Your answer

Preview

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's
...