What's wrong with mysql reset auto increment in codeigniter?

ALTER TABLE tablename AUTO_INCREMENT = 1

There is a very easy way with phpmyadmin under the ( operations tab ),
you can set, in the table options, autoincrement to the number you want.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )