DROP TABLE IF EXISTS News ;
CREATE TABLE News (
Id int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
NewsClassifyId int not null COMMENT '新闻类别编号',
Title varchar(1000) NOT NULL COMMENT '标题',
Image varchar(200) COMMENT '新闻图片',
Contents text NOT NULL COMMENT '新闻内容',
PublishDate datetime null comment '发布时间',
Remark VARCHAR(200) COMMENT' 备注',
PRIMARY KEY (Id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
alter table News add constraint `fk` foreign key (`NewsClassifyId`) references NewsClassify(`Id`);
COMMENT ‘主键’ 备注
PRIMARY KEY (Id) 主键标识符
创建外键:
alter table News add constraint fk
foreign key (NewsClassifyId
) references NewsClassify(Id
);