0

How to reset AUTO_INCREMENT column in MySQL

Background

This article demonstrates how to reset an AUTO_INCREMENT column in MySQL.

Software Environment

  • Windows 7 Professional SP1
  • MySQL 5.6.16 – Community Server (GPL)

Reset AUTO_INCREMENT column

This works for both InnoDB and MyISAM.

Karl San Gabriel

Karl San Gabriel

Java and Enterprise Technologies Expert