navicat pgsql 自增主键
1、创建表CREATE TABLE "my_table"( "id" int4 PRIMARY KEY, "title" VARCHAR);2、创建序列CREATE SEQUENCE "my_table_seq" INCREMENT 1 START 1 NO MINVALUE NO MAXVALUE CACHE 2;3、修改主键自增ALTER TABLE "my_table" ALTER COLUMN "id" SET DEFAULT
原创
2020-09-24 13:33:50 ·
1727 阅读 ·
0 评论