Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

How To Reset Auto_increment Field To 1?

This topic is empty.

Viewing 0 reply threads

Author

Posts
- September 4, 2005 at 7:16 pm #19118
  
  peterlaursen
  Participant
  
  There is no functionality for this is SQLyog. It also is a little dangerous if the autoincr-field is referenced!
  
  You can do as you do, or you can drop the autoincrement-column and create it again. Then rows will be re-numbered
  
  Lots of discussions on the matter here:
  
  http://dev.mysql.com/doc/mysql/en/example-…-increment.html
Author

Posts

Viewing 0 reply threads

You must be logged in to reply to this topic.