reset auto increment

Sometimes database developers need to reset auto increment column in MySQL. Here are different ways to set the auto increment value.