mysql和oracle主键自增

最新推荐文章于 2024-07-20 16:33:27 发布

ALEX%%%@

最新推荐文章于 2024-07-20 16:33:27 发布

阅读量86

点赞数 2

文章标签： mysql oracle 数据库 java 分布式

本文链接：https://blog.csdn.net/weixin_42624574/article/details/140467407

版权

mysql

建表

CREATE TABLE `xxx`.`xxxx` (
   `ID` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
   ........
   PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='xxxx';

实体属性

 @TableId(value = "ID",type = IdType.AUTO)
 private  Long id ;

oracle

建表

CREATE TABLE "xx"."xxxx" (
      ID NUMBER NOT NULL ,
       ......
      CONSTRAINT "XXXX_PK" PRIMARY KEY ("ID")
);
.....


--创建序列

CREATE SEQUENCE xxxx_id_seq START WITH 1 INCREMENT BY 1 NOMAXVALUE;

CREATE OR REPLACE TRIGGER xxxx_trigger
BEFORE INSERT ON xx.xxxxtable
FOR EACH ROW
BEGIN
SELECT xxxx_id_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;