Debian Codegraph @

mysql-test/suite/storage_engine/tbl_standard_opts.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> DEFAULT CHARACTER SET = utf8
3 COLLATE = utf8_general_ci
4 COMMENT = 'standard table options'
5 ;
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `a` int(11) DEFAULT NULL,
10 `b` char(8) DEFAULT NULL
11 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=utf8 COMMENT='standard table options'
12 ALTER TABLE t1 COMMENT = 'table altered';
13 SHOW CREATE TABLE t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `a` int(11) DEFAULT NULL,
17 `b` char(8) DEFAULT NULL
18 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=utf8 COMMENT='table altered'
19 ALTER TABLE t1 ENGINE=MEMORY;
20 SHOW CREATE TABLE t1;
21 Table Create Table
22 t1 CREATE TABLE `t1` (
23 `a` int(11) DEFAULT NULL,
24 `b` char(8) DEFAULT NULL
25 ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='table altered'
26 ALTER TABLE t1 ENGINE=<STORAGE_ENGINE>;
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `a` int(11) DEFAULT NULL,
31 `b` char(8) DEFAULT NULL
32 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=utf8 COMMENT='table altered'
33 ALTER TABLE t1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci;
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `a` int(11) DEFAULT NULL,
38 `b` char(8) CHARACTER SET utf8 DEFAULT NULL
39 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 COMMENT='table altered'
40 DROP TABLE t1;