Set autoincrement value in mysql

Sometimes it is necessary to set the starting value of MySQL auto-increment value.  This can be set as

alter table table_name auto_increment=XXXX

where table_name is the name of the table and XXXX is the starting value of auto increment