@创建表结构自增ID
DB2数据库建表自增ID
CREATE TABLE TEST
(
ID integer generated always as identity (start with 1 increment by 1) NOT NULL,
TYPE VARCHAR(100),
VALUE VARCHAR(100),
CONSTRAINT P_TEST_DIC_KEY_1 PRIMARY KEY (ID)
)
MYSQL数据库建表自增ID
create table test(
id int primary key not null auto_increment,
type varchar(100),
value varchar(100)
)