How can the autoincrement value be reset for both InnoDB and MyISAM tables in MySQL?

To reset the autoincrement value for both InnoDB and MyISAM tables in MySQL, you can simply truncate the table and then re-insert the data. This will reset the autoincrement value to the starting value. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Truncate the table to reset autoincrement value
$sql = "TRUNCATE TABLE table_name";
$conn->query($sql);

// Re-insert data into the table
$sql = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')";
$conn->query($sql);

// Close the connection
$conn->close();

Keywords

autoincrement reset InnoDB MyISAM MySQL

Related Questions