Resetting Auto_Increment

[Hassan Shaikh]

Hi,

The following does not work for InnoDB tables. The manual says "The next 
AUTO_INCREMENT value you want to set for your table (MyISAM). "

ALTER TABLE <table_name> AUTO_INCREMENT = <new_value>;

Any suggestions for InnoDB?

Thanks.

Hassan