Tag: MySQL

After you, for example truncated it, you can reset the AUTO_INCREMENT value with this SQL statement: [sc name=”src” url=”https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql” ]

To truncate (not dropping, truncating only deletes all table rows) all tables in a MySQL database, run this command and replace <database name> with the…