mariadb : dblink Hint

-- 1. create database for dblink create database IF NOT EXISTS dblink1;   -- 2. check dblink for FEDERATED plugin support. show engines; -- FEDERATED -- install plugin federated soname 'ha_federated.so';   -- 3. create server for dblink drop server IF EXISTS dblink1; CREATE SERVER IF NOT EXISTS dblink1  FOREIGN DATA WRAPPER mysql  OPTIONS (USER […]

Read More

mariadb : sql_mode Hint

SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; SET @old_sql_mode = @@global.sql_mode;   SET sql_mode = ''; SET SQL_MODE = CONCAT(@@SQL_MODE, ',EMPTY_STRING_IS_NULL'); SET SQL_MODE = REPLACE(@@SQL_MODE, 'EMPTY_STRING_IS_NULL', '');   SET sql_mode = @old_sql_mode;   /* SET sql_mode = 'ORACLE, EMPTY_STRING_IS_NULL'; PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT   */  

Read More