Mysql生成UUID的操作_MySQL

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;

}