ALTER TABLE tbl AUTO_INCREMENT = 123 as codeigniter active records query?

Question

How to execute ``` ALTER TABLE tblname AUTO_INCREMENT = 123 ``` as codeigniter active records query? There is something called dbforge->modify_column() in codeigniter , do i have to use that, if so how?

Accepted Answer

`$this->db->query('ALTER TABLE tbl_name AUTO_INCREMENT 1');` is working for me.

ALTER TABLE tbl AUTO_INCREMENT = 123 as codeigniter active records query?

Solution

Problem