mysql主鍵id的生成方式(自增、唯一不規則)
1、利用uuid函數生成唯一且不規則的主鍵id
sql:
CREATE TABLE `test` ( `id` varchar(100) COLLATE utf8_estonian_ci NOT NULL COMMENT '唯一不重復', `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 INTO test(id,sex,name,username,password,classes,major,QQ,introducemyself) VALUE(replace(uuid(), '-', ''),1,"小米","xck","001","八班",265,953190259,"我最牛");
執行瞭倆次,生成瞭倆個不同id:
2、id實現自動增長
將類型改為整型,下方選擇自動增長
看DDL:
CREATE TABLE `test` ( `id` bigint(100) NOT NULL AUTO_INCREMENT COMMENT '唯一不重復', `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;
插入一條數據,sql:
INSERT INTO test(sex,name,username,password,classes,major,QQ,introducemyself) VALUE(1,"小米","xck","001","八班",265,953190259,"我最牛");
對應數據庫變化:
到此這篇關於mysql主鍵id的生成方式(自增、唯一不規則)的文章就介紹到這瞭,更多相關mysql主鍵id生成內容請搜索WalkonNet以前的文章或繼續瀏覽下面的相關文章希望大傢以後多多支持WalkonNet!
推薦閱讀:
- MySQL 字段默認值該如何設置
- MySQL 超大表快速刪除方式
- mybatisplus的坑 insert標簽insert into select無參數問題的解決
- SpringBoot集成Flyway進行數據庫版本遷移管理的步驟
- mysql 實現添加時間自動添加更新時間自動更新操作