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;