Debian Codegraph @

mysql-test/suite/storage_engine/create_table.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `a` int(11) DEFAULT NULL
7 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
8 CREATE TABLE IF NOT EXISTS t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
9 Warnings:
10 Note 1050 Table 't1' already exists
11 CREATE TABLE t2 LIKE t1;
12 SHOW CREATE TABLE t2;
13 Table Create Table
14 t2 CREATE TABLE `t2` (
15 `a` int(11) DEFAULT NULL
16 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
17 CREATE TEMPORARY TABLE t2 LIKE t1;
18 SHOW CREATE TABLE t2;
19 Table Create Table
20 t2 CREATE TEMPORARY TABLE `t2` (
21 `a` int(11) DEFAULT NULL
22 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
23 DROP TEMPORARY TABLE t2;
24 DROP TABLE t2;
25 DROP TABLE IF EXISTS t1;
26 CREATE TABLE t1 ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> AS SELECT 1 UNION SELECT 2;
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `1` int(1) NOT NULL DEFAULT 0
31 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
32 SELECT * FROM t1;
33 1
34 1
35 2
36 DROP TABLE t1;
37 SET default_storage_engine = <STORAGE_ENGINE>;
38 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
39 SHOW CREATE TABLE t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `a` int(11) DEFAULT NULL
43 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
44 FLUSH LOGS;
45 DROP TABLE IF EXISTS t1;