|
>>>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.
|