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
Table of contents 1. Overview 2. Name field 3. Ve...
Table of contents Preface Instruction Basics Hook...
Preface Crond is a scheduled execution tool under...
Use pure CSS to change the background color of a ...
MySQL is a relational database management system....
I recently started learning Linux. After reading ...
Table of contents 1. Pull the image 2. Run the im...
Table of contents 1. Values within loop objects...
This article records the process of upgrading MyS...
What is a selector? The role of the selector is t...
I would like to share the installation and config...
<br />This is from the content of Web front-...
Table of contents 1. Installation 2. Use Echarts ...
This article describes the definition and usage o...
Table of contents Overview Application scenarios ...