Breaking News: Grepper is joining You.com. Read the official announcement!

how to set sql_mode for a query in CI model

Grotesque Giraffe answered on June 27, 2021 Popularity 1/10 Helpfulness 1/10

answer how to set sql_mode for a query in CI model

how to set sql_mode for a query in CI model

Comment

$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", "")');

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: model set sql

Link to this answer
Share Copy Link