MySQL Blackhole engine

Moki Lv6
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
show engines;

INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so';

SELECT @@sql_mode;

SET @@sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; - disabled engine blackhole
SET @@sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO'; - enabled engine blackhole

create table table_name
(
column_1 int null
) engine='BLACKHOLE';

alter table table_name engine='BLACKHOLE';
On this page
MySQL Blackhole engine