Jump to content



Welcome to KnowledgeSutra - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!
- - - - -

Can Reset The Id Auto Increment?


26 replies to this topic

#26 Guest_Jamie Goodwin_*

  • Guests

Posted 06 February 2012 - 10:21 AM

I know this is old but I just found this post on Google so I'm going to add my two pence. This can be achieved in PHPMyAdmin by clicking the "Empty" button (top right), or in SQL as:

TRUNCATE TABLE tablename


#27 Guest_Mohammad Asif_*

  • Guests

Posted 20 April 2012 - 10:33 PM

View Postbadinfluence, on 07 September 2005 - 09:54 PM, said:

hi,
Can we reset the id auto increment in the mysql database using by phpMyadmin?
let's say the shoutbox. the id #number table.. somehow i deleted some rows.. and i wanted to re-order/reset the id number acendingly in order rather than skip out..
thks


Its really simple check out this post.

http://www.electrict...nt-value-mysql/




Reply to this topic


This post will need approval from a moderator before this post is shown.

  


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users