sql语句创建外键关联的完整实例
<p>以创建学生教师表为例: 学生 id 关联教师 tid</p>
<p>
<strong><em>学生表: student</em></strong></p>
<p>
<img title="sql语句创建外键关联的完整实例" alt="sql语句创建外键关联的完整实例" src="https://zhuji.jb51.net/uploads/img/202305/11209a7b3ee7379441aedb7627ad69ee.jpg"></p>
<p>
<strong><em>教师表: teacher</em></strong></p>
<p>
<img title="sql语句创建外键关联的完整实例" alt="sql语句创建外键关联的完整实例" src="https://zhuji.jb51.net/uploads/img/202305/3afdf0a7454ecb295a4da26f1bb88e67.jpg"></p>
<p>
<strong><em>sql语句 :</em></strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_422162">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">use school;</code>
</div>
<div class="line number2 index1 alt1">
</div>
<div class="line number3 index2 alt2">
<code class="sql keyword">create</code> <code class="sql keyword">table</code> <code class="sql plain">student(</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">id </code><code class="sql keyword">int</code><code class="sql plain">(10) </code><code class="sql color1">not</code> <code class="sql color1">null</code> <code class="sql keyword">primary</code> <code class="sql keyword">key</code><code class="sql plain">,</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql keyword">name</code> <code class="sql keyword">varchar</code><code class="sql plain">(30) </code><code class="sql keyword">default</code> <code class="sql color1">null</code><code class="sql plain">,</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">tid </code><code class="sql keyword">int</code><code class="sql plain">(10) </code><code class="sql keyword">default</code> <code class="sql color1">null</code><code class="sql plain">,</code>
</div>
<div class="line number7 index6 alt2">
<code class="sql keyword">key</code> <code class="sql plain">`fktid` (`tid`),</code>
</div>
<div class="line number8 index7 alt1">
<code class="sql keyword">constraint</code> <code class="sql plain">`fktid` </code><code class="sql keyword">foreign</code> <code class="sql keyword">key</code><code class="sql plain">(`tid`) </code><code class="sql keyword">references</code> <code class="sql plain">`teacher` (`id`)</code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">)engine=innodb </code><code class="sql keyword">default</code> <code class="sql plain">charset=utf8</code>
</div>
<div class="line number10 index9 alt1">
</div>
<div class="line number11 index10 alt2">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">student </code><code class="sql keyword">values</code><code class="sql plain">(1,</code><code class="sql string">'小明'</code><code class="sql plain">,1);</code>
</div>
<div class="line number12 index11 alt1">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">student </code><code class="sql keyword">values</code><code class="sql plain">(2,</code><code class="sql string">'小红'</code><code class="sql plain">,1);</code>
</div>
<div class="line number13 index12 alt2">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">student </code><code class="sql keyword">values</code><code class="sql plain">(3,</code><code class="sql string">'小刚'</code><code class="sql plain">,1);</code>
</div>
<div class="line number14 index13 alt1">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">student </code><code class="sql keyword">values</code><code class="sql plain">(4,</code><code class="sql string">'小王'</code><code class="sql plain">,1);</code>
</div>
<div class="line number15 index14 alt2">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">student </code><code class="sql keyword">values</code><code class="sql plain">(5,</code><code class="sql string">'小智'</code><code class="sql plain">,1);</code>
</div>
<div class="line number16 index15 alt1">
</div>
<div class="line number17 index16 alt2">
<code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql plain">student;</code>
</div>
<div class="line number18 index17 alt1">
</div>
<div class="line number19 index18 alt2">
<code class="sql keyword">create</code> <code class="sql keyword">table</code> <code class="sql plain">teacher (</code>
</div>
<div class="line number20 index19 alt1">
<code class="sql plain">id </code><code class="sql keyword">int</code><code class="sql plain">(10) </code><code class="sql keyword">primary</code> <code class="sql keyword">key</code> <code class="sql color1">not</code> <code class="sql color1">null</code><code class="sql plain">,</code>
</div>
<div class="line number21 index20 alt2">
<code class="sql keyword">name</code> <code class="sql keyword">varchar</code> <code class="sql plain">(30) </code><code class="sql keyword">default</code> <code class="sql color1">null</code>
</div>
<div class="line number22 index21 alt1">
<code class="sql plain">)engine=innodb </code><code class="sql keyword">default</code> <code class="sql plain">charset=utf8</code>
</div>
<div class="line number23 index22 alt2">
</div>
<div class="line number24 index23 alt1">
</div>
<div class="line number25 index24 alt2">
<code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">teacher </code><code class="sql keyword">values</code><code class="sql plain">(1,</code><code class="sql string">'陈老师'</code><code class="sql plain">);</code>
</div>
<div class="line number26 index25 alt1">
<code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql plain">teacher;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
重点: 外键关联语句,会手写才可以!</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_110488">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql keyword">key</code> <code class="sql plain">`fktid` (`tid`),</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql keyword">constraint</code> <code class="sql plain">`fktid` </code><code class="sql keyword">foreign</code> <code class="sql keyword">key</code><code class="sql plain">(`tid`) </code><code class="sql keyword">references</code> <code class="sql plain">`teacher` (`id`)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
<strong>总结</strong></p>
<p>
到此这篇关于sql语句创建外键关联的文章就介绍到这了,更多相关sql创建外键关联内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持！</p>
<p>
原文链接：https://blog.csdn.net/SoULikeMe/article/details/113368984</p>
頁:
[1]