Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_row_format.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> ROW_FORMAT=DYNAMIC;
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `a` int(11) DEFAULT NULL,
7 `b` char(8) DEFAULT NULL
8 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
9 ALTER TABLE t1 ROW_FORMAT=FIXED;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `a` int(11) DEFAULT NULL,
14 `b` char(8) DEFAULT NULL
15 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED
16 ALTER TABLE t1 ROW_FORMAT=PAGE;
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `a` int(11) DEFAULT NULL,
21 `b` char(8) DEFAULT NULL
22 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 ROW_FORMAT=PAGE
23 ALTER TABLE t1 ROW_FORMAT=COMPACT;
24 SHOW CREATE TABLE t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `a` int(11) DEFAULT NULL,
28 `b` char(8) DEFAULT NULL
29 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
30 DROP TABLE t1;