create table TAB_BOOKINFO(
id bigint
primary key auto_increment,
name varchar(20),
author varchar(20),
publisher varchar(20),
price double,
image varchar(30),
catelog bigint
references TAB_CATELOG(id)
);
麻烦大家帮我看一下,上面代码中:(id bigint
primary key auto_increment)这句代码是什么意思?
还有(catelog bigint
references TAB_CATELOG(id))这句代码是什么意思?
id bigint
primary key auto_increment,
name varchar(20),
author varchar(20),
publisher varchar(20),
price double,
image varchar(30),
catelog bigint
references TAB_CATELOG(id)
);
麻烦大家帮我看一下,上面代码中:(id bigint
primary key auto_increment)这句代码是什么意思?
还有(catelog bigint
references TAB_CATELOG(id))这句代码是什么意思?
--定义id为bigint类型,并设置为主键,id是自动增加列catelog bigint references TAB_CATELOG(id)
--catelog是外键,引用CATELOG表的id列