{"id":24552,"date":"2024-03-16T03:22:42","date_gmt":"2024-03-16T03:22:42","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/"},"modified":"2024-03-22T04:00:58","modified_gmt":"2024-03-22T04:00:58","slug":"how-to-set-up-foreign-keys-when-creating-a-table-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/","title":{"rendered":"How to set up foreign keys when creating a table in MySQL?"},"content":{"rendered":"<p>In MySQL, you can use the following syntax to set up foreign keys:<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE \u8868\u540d (\r\n    \u5217\u540d1 \u6570\u636e\u7c7b\u578b,\r\n    \u5217\u540d2 \u6570\u636e\u7c7b\u578b,\r\n    ...\r\n    FOREIGN KEY (\u5217\u540d1) REFERENCES \u53c2\u8003\u8868\u540d(\u53c2\u8003\u5217\u540d),\r\n    ...\r\n);\r\n<\/code><\/pre>\n<p>In the above syntax, column 1 is the name of the column where the foreign key will be set, reference table name is the name of the table to be referenced, and reference column name is the name of the column to be referenced.<\/p>\n<p>Here is an example:<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE \u88681 (\r\n    id INT PRIMARY KEY,\r\n    name VARCHAR(50)\r\n);\r\n\r\nCREATE TABLE \u88682 (\r\n    id INT PRIMARY KEY,\r\n    col1 INT,\r\n    col2 VARCHAR(50),\r\n    FOREIGN KEY (col1) REFERENCES \u88681(id)\r\n);\r\n<\/code><\/pre>\n<p>In the example above, the col1 column in table 2 is set as a foreign key, referencing the id column in table 1.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, you can use the following syntax to set up foreign keys: CREATE TABLE \u8868\u540d ( \u5217\u540d1 \u6570\u636e\u7c7b\u578b, \u5217\u540d2 \u6570\u636e\u7c7b\u578b, &#8230; FOREIGN KEY (\u5217\u540d1) REFERENCES \u53c2\u8003\u8868\u540d(\u53c2\u8003\u5217\u540d), &#8230; ); In the above syntax, column 1 is the name of the column where the foreign key will be set, reference table name is the name of [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-24552","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to set up foreign keys when creating a table in MySQL? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to set up foreign keys when creating a table in MySQL?\" \/>\n<meta property=\"og:description\" content=\"In MySQL, you can use the following syntax to set up foreign keys: CREATE TABLE \u8868\u540d ( \u5217\u540d1 \u6570\u636e\u7c7b\u578b, \u5217\u540d2 \u6570\u636e\u7c7b\u578b, ... FOREIGN KEY (\u5217\u540d1) REFERENCES \u53c2\u8003\u8868\u540d(\u53c2\u8003\u5217\u540d), ... ); In the above syntax, column 1 is the name of the column where the foreign key will be set, reference table name is the name of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T03:22:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:00:58+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How to set up foreign keys when creating a table in MySQL?\",\"datePublished\":\"2024-03-16T03:22:42+00:00\",\"dateModified\":\"2024-03-22T04:00:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\"},\"wordCount\":93,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\",\"name\":\"How to set up foreign keys when creating a table in MySQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T03:22:42+00:00\",\"dateModified\":\"2024-03-22T04:00:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set up foreign keys when creating a table in MySQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to set up foreign keys when creating a table in MySQL? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to set up foreign keys when creating a table in MySQL?","og_description":"In MySQL, you can use the following syntax to set up foreign keys: CREATE TABLE \u8868\u540d ( \u5217\u540d1 \u6570\u636e\u7c7b\u578b, \u5217\u540d2 \u6570\u636e\u7c7b\u578b, ... FOREIGN KEY (\u5217\u540d1) REFERENCES \u53c2\u8003\u8868\u540d(\u53c2\u8003\u5217\u540d), ... ); In the above syntax, column 1 is the name of the column where the foreign key will be set, reference table name is the name of [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T03:22:42+00:00","article_modified_time":"2024-03-22T04:00:58+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How to set up foreign keys when creating a table in MySQL?","datePublished":"2024-03-16T03:22:42+00:00","dateModified":"2024-03-22T04:00:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/"},"wordCount":93,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/","name":"How to set up foreign keys when creating a table in MySQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T03:22:42+00:00","dateModified":"2024-03-22T04:00:58+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-foreign-keys-when-creating-a-table-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to set up foreign keys when creating a table in MySQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=24552"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24552\/revisions"}],"predecessor-version":[{"id":58594,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24552\/revisions\/58594"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=24552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=24552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=24552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}