1.在数据库中创建序列,并设置 起始值、步长、最大值、最小值,名称可以自己定义
DROP SEQUENCE IF EXISTS tb_mht_id;
CREATE SEQUENCE "tb_mht_id"
INCREMENT 1
START 1
NO MINVALUE
NO MAXVALUE
CACHE 2;
alter table tb_mht alter column id set default nextval('tb_mht_id');
2.在实体类中添加注解
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
向表中插入值:
insert into _category(name,description)values('yu','bihao');
不可以这样,会报错:
insert into _category(id,name,description)values(_category_id_seq.nextval,'yu','bihao');
参考:https://www.cnblogs.com/dabenhou/p/14792718.html