Debian Codegraph @

mysql-test/suite/storage_engine/col_opt_default.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN> DEFAULT '0') ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 SHOW COLUMNS IN t1;
4 Field Type Null Key Default Extra
5 a int(11) # 0
6 INSERT INTO t1 (a) VALUES (1);
7 SELECT a FROM t1;
8 a
9 1
10 ALTER TABLE t1 ADD COLUMN b <CHAR_COLUMN> DEFAULT '';
11 SHOW COLUMNS IN t1;
12 Field Type Null Key Default Extra
13 a int(11) # 0
14 b char(8) #
15 INSERT INTO t1 (b) VALUES ('a');
16 SELECT a,b FROM t1;
17 a b
18 0 a
19 1
20 DROP TABLE t1;