mySql主键和外键的建表语句示例:
- create table threads(
- id int(11),
- title varchar(100),
- content varchar(1000),
- uid int(11),
- bid int(11),
- constraint pk_id primary key (`id`),
- constraint fk_uid foreign key (`uid`) references `user`(`userid`),
- constraint fk_bid foreign key (`bid`) references `board`(`id`)
- );