mysql truncate
It’s a very useful command, when we are populating a database, sometimes we found little issues that forced us to empty a table and then refilling it, but, the auto increment indexes does not reset, so the field with auto increment starts in another value different to zero, then, if we use truncate, the auto increment field reset the counter and begins to zero!
For more info visit the official documentation here. Works different on MyIsam and InnoDB tables.
