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';
|
