identity 1 1 mysql_identity在mysql中怎么用啊以下代码的错误在哪里

identity在mysql中怎么用啊以下代码的错误在哪里

关注:112  答案:2  mip版

解决时间 2021-01-25 10:23

提问者妳狠僤莼

2021-01-24 17:40

use bbs

create table TBL_BOARD

(

boardId smallint not null primary key,

boardName varchar(50) not null,

parentId smallint not null

)

create table TBL_REPLY

(

replyId int identity(1,1) primary key,

title varchar(50) not null,

content text not null,

publishTime timestamp not null,

modifyTime timestamp not null,tbl_board

uId smallint not null,

topicId smallint not null

)

create table TBL_TOPIC

(

topicId identity(1,1) int primary key,

title varchar(50) not null,

content text n