Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
10.0.20
-
Ubuntu 14.04
Description
>>>CREATE TABLE t (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4
>>>show create table t;
--------------------------------------------------------------------+
CREATE TABLE `t` ( |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`id`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 --------------------------------------------------------------------+ |
the "AUTO_INCREMENT=1000" didn't take affect.