Oracle和MySQL设置主键id为uuid的方式

Oracle设置uuid比较简单，只要用 default SYS_GUID() 修饰字段id就行

CREATE TABLE product(  
	id varchar2(32) default SYS_GUID() PRIMARY KEY,  
	productNum VARCHAR2(50) NOT NULL,  
	productName VARCHAR2(50),  
	cityName VARCHAR2(50),  
	DepartureTime timestamp,  
	productPrice Number,  
	productDesc VARCHAR2(500),  
	productStatus INT,  
	CONSTRAINT product UNIQUE (id, productNum) )

Mysql要使用触发器来实现，具体如下：

CREATE TABLE product(  
id varchar(32) PRIMARY KEY,  
productNum VARCHAR(50) NOT NULL,  
productName VARCHAR(50),  
cityName VARCHAR(50),
DepartureTime timestamp,  
productPrice int(10),  
productDesc VARCHAR(500),  
productStatus INT,
UNIQUE KEY `product` (`id`,`productNum`)
);
delimiter ||
CREATE TRIGGER `product_before_insert` BEFORE INSERT ON `product` FOR EACH ROW 
BEGIN
IF new.id is NULL THEN
	SET new.id = replace(uuid,"-","");
	END IF; 
END;
||