1. Use the uuid function to generate a unique and irregular primary key idsql: CREATE TABLE `test` ( `id` varchar(100) COLLATE utf8_estonian_ci NOT NULL COMMENT 'Unique and non-duplicate', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sex` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `classes` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `major` int(255) DEFAULT NULL, `QQ` int(20) DEFAULT NULL, `introducemyself` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci ROW_FORMAT=DYNAMIC; surface: Insert statement: INSERT INTO test(id,sex,name,username,password,classes,major,QQ,introducemyself) VALUE(replace(uuid(), '-', ''),1,"小米","xck","001","班八",265,953190259,"我最牛"); Executed twice, generating two different ids: 2. Automatic growth of idChange the type to integer and select auto-growth below See DDL: CREATE TABLE `test` ( `id` bigint(100) NOT NULL AUTO_INCREMENT COMMENT 'unique and non-duplicate', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sex` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `classes` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, `major` int(255) DEFAULT NULL, `QQ` int(20) DEFAULT NULL, `introducemyself` varchar(255) COLLATE utf8_estonian_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci ROW_FORMAT=DYNAMIC; Insert a piece of data, sql: INSERT INTO test(sex,name,username,password,classes,major,QQ,introducemyself) VALUE(1,"小米","xck","001","班八",265,953190259,"我最牛"); Corresponding database changes: This is the end of this article about how to generate MySQL primary key ID (self-increment, unique and irregular). For more relevant MySQL primary key ID generation content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future! You may also be interested in:
|
<<: The iframe frame sets the white background to transparent in IE browser
>>: How to inherit CSS line-height
W3C, an organization founded in 1994, aims to unl...
1. Preliminary preparation (windows7+mysql-8.0.18...
【Foreword】 Recently I want to stress test ITOO...
1. Install the built-in Linux subsystem of win10 ...
Table of contents Symbol Data Type The reason why...
To install a virtual machine on a Windows system,...
1. First log in to the Alibaba Cloud website to r...
Preface The writing of front-end code can never e...
TeamCenter12 enters the account password and clic...
1. Check the database time zone show variables li...
Create a table CREATE TABLE `map` ( `id` int(11) ...
Preface: As a giant in the IT industry, Microsoft...
1. View the types of fields in the table describe...
Trident core: IE, MaxThon, TT, The World, 360, So...
one. Remote deployment using tomcat 1.1 Problems ...