Sql

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

SET GLOBAL sql_mode = 'modes';
SET SESSION sql_mode = 'modes';

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

PREVIOUS	NEXT

Code Example
Sql :: choose only one for each distinct collumn regardless of other columns
Sql :: sql group by example
Sql :: sql sum of same record
Sql :: run psql postgres docker
Sql :: mysql select row with max value group by
Sql :: See Foreign Key
Sql :: sql select most frequent value in group
Sql :: oracle undo tablespace list by user
Sql :: close external port 3306 with iptables
Sql :: concat all rows in sql postgres
Sql :: sql server remove 0 from left
Sql :: change database postgres
Sql :: Write SQL in ruby on rails
Sql :: if else sql
Sql :: postgres select except
Sql :: open postgresql.conf in centos
Sql :: mysql sort asc numeric
Sql :: minus equivalent in my sql
Sql :: sql rename column in select
Sql :: peewee print sql
Sql :: how to add more columns to a table in mysql
Sql :: mysql grouping functions
Sql :: get comma separated values in mysql with group by
Sql :: tsql generate rows
Sql :: compression of dabatase mysqldumo
Sql :: create user with encrypted password postgresql
Sql :: sql where clause
Sql :: in sql
Sql :: what is top n result in sql
Sql :: three inner joins sql