/SQL/How to set sql_mode for a query in CI model

How to set sql_mode for a query in CI model

$this->db->query('SET SESSION sql_mode = ""');

// ONLY_FULL_GROUP_BY
$this->db->query('SET SESSION sql_mode =
                  REPLACE(REPLACE(REPLACE(
                  @@sql_mode,
                  "ONLY_FULL_GROUP_BY,", ""),
                  ",ONLY_FULL_GROUP_BY", ""),
                  "ONLY_FULL_GROUP_BY", "")');

Source: stackoverflow.com

Similar codes

1 vote399 views2 answers
Maximum number of tables in mysql
SQL
0 vote459 views1 answer
Mysql get nested records
SQL
2 votes408 views2 answers
Mysql on duplicate key update get value from values
SQL
3 votes334 views1 answer
What is having clause
SQL
0 vote432 views1 answer
Split first name and last name in sql
SQL
0 vote351 views2 answers
How to relationship query two different tables in MySQL
SQL
6 votes403 views2 answers
How to copy data in sql
SQL
0 vote417 views1 answer
Download sql file of countries names
SQL
0 vote438 views1 answer
Why do we need data structure in sql
SQL
7 votes326 views1 answer
Mysql load data infile csv
SQL