postgresql 创建id自增，id恢复最大

浪淘沙8个月前 (01-19)数据库167

CREATE SEQUENCE stu_id_seq

SELECT setval(
  'stu_id_seq',
  (SELECT GREATEST(MAX(id), 1) FROM stu)
);

返回列表

select distinct(TO_CHAR(rq, 'YYYY-MM-DD')) from fz_rl order by...

delete from article_author;dbcc checkident('article_author',reseed,0)...

delete from article_author;dbcc checkident('article_author',reseed,0)...

SELECT datname AS database_name, oid ...

AUTOINCREMEN...

TRUNCATE TABLE tpl_template_class RESTART IDENTITY; ALTER SEQUENCE ...

xxt.red 校校通