46 lines
930 B
Plaintext
46 lines
930 B
Plaintext
# MySQL
|
|
CREATE TABLE a (id INT PRIMARY KEY) AUTOEXTEND_SIZE=4M;
|
|
SHOW WARNINGS;
|
|
DROP TABLE a;
|
|
|
|
# MariaDB
|
|
CREATE TABLE a (id INT PRIMARY KEY) PAGE_CHECKSUM=1;
|
|
SHOW WARNINGS;
|
|
DROP TABLE a;
|
|
|
|
CREATE TABLE b (id INT PRIMARY KEY) PAGE_COMPRESSED=1;
|
|
SHOW WARNINGS;
|
|
DROP TABLE b;
|
|
|
|
CREATE TABLE c (id int PRIMARY KEY) PAGE_COMPRESSION_LEVEL=1;
|
|
SHOW WARNINGS;
|
|
DROP TABLE c;
|
|
|
|
CREATE TABLE d (id int PRIMARY KEY) TRANSACTIONAL=0;
|
|
SHOW WARNINGS;
|
|
DROP TABLE d;
|
|
|
|
CREATE TABLE e (id int PRIMARY KEY) IETF_QUOTES=YES;
|
|
SHOW WARNINGS;
|
|
DROP TABLE e;
|
|
|
|
CREATE TABLE f (id int PRIMARY KEY) SEQUENCE=1;
|
|
SHOW WARNINGS;
|
|
DROP TABLE f;
|
|
|
|
CREATE TABLE g (id int PRIMARY KEY) ENGINE=MyISAM;
|
|
SHOW WARNINGS;
|
|
DROP TABLE g;
|
|
|
|
CREATE TABLE h (id int PRIMARY KEY) ENGINE=Aria;
|
|
SHOW WARNINGS;
|
|
DROP TABLE h;
|
|
|
|
CREATE TABLE i (id int PRIMARY KEY) ENGINE=MyRocks;
|
|
SHOW WARNINGS;
|
|
DROP TABLE i;
|
|
|
|
CREATE TABLE j (id int PRIMARY KEY) ENGINE=TokuDB;
|
|
SHOW WARNINGS;
|
|
DROP TABLE j;
|