AUTO_INCREMENT => ONE OF THE COOL FEATURE
Suppose you have postid in your post table. AND you want that whenever anyone submit a post the postid gets incremented by one automatically.(without the user)
USER JUST SUBMIT THE POST or OTHER COLUMN FIELD . But postid is incrementing by itself whenever anyone enters. You can implement it on a primary key column.
Resenting the auto_increment :
#alter table abc auto_increment = 2301;
#TRUNCATE TABLE table_name
(WARNING Truncate command will remove all the data from the table)
Go to table=>Operation=>Enter Auto_Increment value