简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Mysql生成UUID的操作_MySQL

WBOY
Release： 2016-06-01 13:36:40
Original
2657 people have browsed it

bitsCN.com


Mysql生成UUID的操作

 

Hibernate中这样配置主键生成后，mysql中并未指定主键生成机制，

使用Navicat通过sql语句insert数据时仍需指定Id，  

 

Java代码  

INSERT INTO g_distinct VALUES ( replace(uuid(),'-',''),'110101','东城区','110100');  

 

Java代码   

@Id  

@GenericGenerator(name = "generator", strategy = "uuid.hex")  

@GeneratedValue(generator = "generator")  

@Column(name = "LOCATION_ID", length = 40)  

public String getLocationId() {  

    return locationId;  

}  

bitsCN.com
Related labels：
insert mysql replace sql statement
source：php.cn
Previous article：mysql新建用户远程登录_MySQL Next article：《Expert MySQL》翻译chapter2.解剖数据库系统(2)_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Regular expression to replace several symbols with HTML tags I'm trying to build a regular expression that replaces all symbols "$$" with som...
From 2024-04-01 21:01:01
0
2
358
How to eliminate specific repeated characters in a string? I have a simple string with some repeating characters. Can someone please help me fix the ...
From 2024-03-31 10:50:33
0
2
368
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！