Ability to specify index for query build from

You can always do anything almost using a standard query with ci even create tables etc;

PHP Code:

$sql = "CREATE INDEX index_name ON table_name (column_name)";
$sql = "CREATE UNIQUE INDEX index_name ON table_name (column_name)";

$query = $this->db->query($sql); 


Using this method you can do almost anything with the database.

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

Joined CodeIgniter Community 2009.  ( Skype: insitfx )