---DB version: percona server 5.7.27-30-log ---utf8 CREATE TABLE `emp` ( `id` bigint (20) unsigned NOT NULL AUTO_INCREMENT, `empno` mediumint(8) unsigned NOT NULL DEFAULT '0' , `ename` varchar (20) NOT NULL DEFAULT '' , `job` varchar (9) NOT NULL DEFAULT '' , `mgr` mediumint(8) unsigned NOT NULL DEFAULT '0' , `hiredate` date NOT NULL , `sal` decimal (7,2) NOT NULL , `comm` decimal (7,2) NOT NULL , `deptno` mediumint(8) unsigned NOT NULL DEFAULT '0' , PRIMARY KEY (`id`), KEY `test_utf8` (`ename`) ) ENGINE=InnoDB AUTO_INCREMENT=14399998 DEFAULT CHARSET=utf8; ---utf8mb4 CREATE TABLE `emp_mb4` ( `id` bigint (20) unsigned NOT NULL AUTO_INCREMENT, `empno` mediumint(8) unsigned NOT NULL DEFAULT '0' , `ename` varchar (20) NOT NULL DEFAULT '' , `job` varchar (9) NOT NULL DEFAULT '' , `mgr` mediumint(8) unsigned NOT
|