PostgreSQL
postgresql数据库
Take^that
可控的事情要谨慎,不可控的事情要乐观。
展开
-
PostgreSQL update set from 两表联合更新
update t_business tbset system_id = ir.application_idfrom t_business_irregular irwhere tb.affected_business = ir.application_name update t_business tbset system_id = ir.application_idfrom t_business_irregular irwhere tb.fault_system = ir.applicatio原创 2022-04-20 10:34:56 · 5040 阅读 · 1 评论 -
PostgreSQL 主键自增设置
postgreSQL 自增需要使用序列使用SERIALCREATE TABLE users(id SERIAL primary key ,name character varying,password character varying)自动创建名为users_id_seq的序列,且MAXVALUE=9223372036854775807其余值为1先创建序列,然后设置字段的自增CREATE SEQUENCE users_id_seqSTART WITH 1INCREMEN转载 2021-12-01 20:13:59 · 362 阅读 · 0 评论