开始从默认值自动生成自动增量列值 [英] Start generating auto increment column value from default in slick

问题描述

我有一个表列保存自动增量值.我想从指定的vlaue开始增加. 如何在sdl ddl中指定此功能.

I having a table column holds auto increment value. I want to start incrementing from specified vlaue. How can i specify this functionality in slick ddl.

我在光滑的表创建列中使用的代码是:

Code i am using for column of table creation in slick is :

def id = column[Long]("id", O.PrimaryKey, O.AutoInc, O.NotNull)

我碰到过这篇文章，但是没有找到确切的解决方案.

I have come across this article but didn't find exact solution.

create table "COCKTAIL" (
  "ID" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 100000) NOT NULL PRIMARY KEY,
  "NAME" VARCHAR NOT NULL)

有人可以帮助我实现这一目标吗?

Can someone help me how to achieve this.

推荐答案

O.Default(...)呢?在这里查看: ColumnOption .

def id = column[Long]("id", O.PrimaryKey, O.AutoInc, O.NotNull,O.Default(100000))

这篇关于开始从默认值自动生成自动增量列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！