25 lines
720 B
Plaintext
25 lines
720 B
Plaintext
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY DEFAULT '0', a INT(11), b CHAR(8)) ENGINE=xengine;
|
|
Warnings:
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`pk` int(11) NOT NULL DEFAULT '0',
|
|
`a` int(11) DEFAULT NULL,
|
|
`b` char(8) COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
PRIMARY KEY (`pk`)
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
SHOW COLUMNS IN t1;
|
|
Field Type Null Key Default Extra
|
|
pk int(11) NO PRI 0
|
|
a int(11) YES NULL
|
|
b char(8) YES NULL
|
|
INSERT INTO t1 VALUES (1, 1,'a');
|
|
INSERT INTO t1 (a,b) VALUES (2,'b');
|
|
SELECT a,b FROM t1;
|
|
a b
|
|
1 a
|
|
2 b
|
|
DROP TABLE t1;
|