新建一张表,设置主键字段,这个等下要关联另外表的外键,如图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/342ac65c1038534363f108418313b07eca808890?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b87e950352ac65c863be913ebf2b21193138a90?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
在新建一张表,在新建表时,添加一个外键的字段,如图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3bf33a87e950352a535faa684343fbf2b2118b90?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
点击外键功能,切换页面如图,这里就可以设置外键了
请点击输入图片描述
先取个外键的名称,在选择外键字段,如图
请点击输入图片描述
选择你外键表所在的数据库,如图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600abf080d7f950352ac65cb790?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选择外键表,如图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e850352ac65c1038c44041a2a2119313b07e8990?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
再选择外键表主键字段即外键,如图,这样点击保存外键就创建成功了,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5ab5c9ea15ce36d35a3a0c502af33a87e950b190?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
或者写如图的语句来创建外键,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faf2b2119313b07e5683df681cd7912397dd8c90?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述