Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql type conversion
Sql :: Getting error while running 50 MB script on SQL Server
Sql :: how to know which table has more data oracle sql
Sql :: create view in sql server that contain multiple select statements
Sql :: xampp increame mysql speed
Sql :: missing index on mssql rds database
Sql :: snowflake last query id
Sql :: oracle archivemode
Sql :: odoo there is no primary key for referenced table "res_users"
Sql :: id INT NOT NULL AUTO_INCREMENT
Sql :: synapse sql table set pk
Sql :: mysql – Error ‘Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted’ on query.
Sql :: md5 encryption for existing records
Sql :: modify xml in sql server
Sql :: change authentication plugin from auth_sock to mysql_native_password for a specific user
Sql :: numeric in sql
Sql :: sqlite3 not commit
Sql :: implicit inner join table alias with id values
Sql :: grant privileges when craeting a user
Sql :: list of schema with sizes (relative and absolute) in a PostgreSQL database
Sql :: how set default setting of toolbar in sql developer
Sql :: bus source and destination equal to destination and source of another by sql query
Sql :: To Create directory
Sql :: get who is hired in january in sql
Sql :: how to install firebird
Sql :: oracle grant create job
Sql :: oracle exchange partition
Sql :: store case result sql
Sql :: characters found after end of sql statement
Sql :: sql query for login with email or username

Search

SQL

how to set sql_mode for a query in CI model

ADD CONTENT