Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_max_rows.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> MAX_ROWS=10000000;
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 MAX_ROWS=10000000
9 ALTER TABLE t1 MAX_ROWS=30000000;
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 MAX_ROWS=30000000
16 DROP TABLE t1;