<legend id='koYJD'><style id='koYJD'><dir id='koYJD'><q id='koYJD'></q></dir></style></legend>

    1. <i id='koYJD'><tr id='koYJD'><dt id='koYJD'><q id='koYJD'><span id='koYJD'><b id='koYJD'><form id='koYJD'><ins id='koYJD'></ins><ul id='koYJD'></ul><sub id='koYJD'></sub></form><legend id='koYJD'></legend><bdo id='koYJD'><pre id='koYJD'><center id='koYJD'></center></pre></bdo></b><th id='koYJD'></th></span></q></dt></tr></i><div id='koYJD'><tfoot id='koYJD'></tfoot><dl id='koYJD'><fieldset id='koYJD'></fieldset></dl></div>
        <bdo id='koYJD'></bdo><ul id='koYJD'></ul>

        <tfoot id='koYJD'></tfoot>

        <small id='koYJD'></small><noframes id='koYJD'>

      1. MySQL:错误 1215 (HY000):无法添加外键约束

        MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint(MySQL:错误 1215 (HY000):无法添加外键约束)

            <bdo id='41akp'></bdo><ul id='41akp'></ul>
          • <tfoot id='41akp'></tfoot>

          • <small id='41akp'></small><noframes id='41akp'>

            <i id='41akp'><tr id='41akp'><dt id='41akp'><q id='41akp'><span id='41akp'><b id='41akp'><form id='41akp'><ins id='41akp'></ins><ul id='41akp'></ul><sub id='41akp'></sub></form><legend id='41akp'></legend><bdo id='41akp'><pre id='41akp'><center id='41akp'></center></pre></bdo></b><th id='41akp'></th></span></q></dt></tr></i><div id='41akp'><tfoot id='41akp'></tfoot><dl id='41akp'><fieldset id='41akp'></fieldset></dl></div>
            <legend id='41akp'><style id='41akp'><dir id='41akp'><q id='41akp'></q></dir></style></legend>
              <tbody id='41akp'></tbody>

                • 本文介绍了MySQL:错误 1215 (HY000):无法添加外键约束的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我已阅读数据库系统概念,第 6 版,Silberschatz.我将在 MySQL 上的 OS X 上实现第 2 章中显示的大学数据库系统.但是我在创建表 course 时遇到了麻烦.表 department 看起来像

                  I have read Database system concepts, 6th edition, Silberschatz. I'm going to implement the university database system shown in chapter 2 on OS X on MySQL. But I have a trouble with creating the table course. the table department looks like

                  mysql> select * from department
                      -> ;
                  +------------+----------+-----------+
                  | dept_name  | building | budget    |
                  +------------+----------+-----------+
                  | Biology    | Watson   |  90000.00 |
                  | Comp. Sci. | Taylor   | 100000.00 |
                  | Elec. Eng. | Taylor   |  85000.00 |
                  | Finance    | Painter  | 120000.00 |
                  | History    | Painter  |  50000.00 |
                  | Music      | Packard  |  80000.00 |
                  | Physics    | Watson   |  70000.00 |
                  +------------+----------+-----------+
                  
                  mysql> show columns from department
                      -> ;
                  +-----------+---------------+------+-----+---------+-------+
                  | Field     | Type          | Null | Key | Default | Extra |
                  +-----------+---------------+------+-----+---------+-------+
                  | dept_name | varchar(20)   | NO   | PRI |         |       |
                  | building  | varchar(15)   | YES  |     | NULL    |       |
                  | budget    | decimal(12,2) | YES  |     | NULL    |       |
                  +-----------+---------------+------+-----+---------+-------+
                  

                  创建表course 导致以下错误.

                  Creating the table course causes the following error.

                  mysql> create table course
                      -> (course_id varchar(7),
                      -> title varchar (50),
                      -> dept_name varchar(20),
                      -> credits numeric(2,0),
                      -> primary key(course_id),
                      -> foreign key (dept_name) references department);
                  ERROR 1215 (HY000): Cannot add foreign key constraint
                  

                  在google上搜索外键约束后,我才知道外键约束"这个词表示表中外键列的数据course必须存在于表中的主键列中部门.但是我在插入数据时应该会遇到这个错误.

                  after searching google for foreign key constraint, I have just learned that the word 'foreign key constraint' indicates that data from foreign key column in the table course must exist in primary key column in the table department. But I should have met this error when inserting data.

                  如果不是,为什么作者让我执行那个 SQL 语句?

                  If not, why does author make me execute that SQL statement?

                  如果我真的执行了错误的SQL语句,是否需要在插入数据后指定课程表中的dept_name作为外键?

                  If I really execute erroneous SQL statement, Does I have to designate dept_name in course table as foreign key after inserting some data?

                  EDIT :在 mysql> 中输入 set foreign_key_checks=0 不能修复错误.

                  EDIT : typing set foreign_key_checks=0 into mysql> does not fix the error.

                  ------------------------
                  LATEST FOREIGN KEY ERROR
                  ------------------------
                  2013-09-21 16:02:20 132cbe000 Error in foreign key constraint of table university/course:
                  foreign key (dept_name) references department):
                  Syntax error close to:
                  )
                  mysql> set foreign_key_checks=0
                      -> ;
                  Query OK, 0 rows affected (0.00 sec)
                  mysql> create table course
                      -> (course_id varchar(7),
                      -> title varchar(50),
                      -> dept_name varchar(20),
                      -> credits numeric(2,0),
                      -> primary key(course_id),
                      -> foreign key (dept_name) references department);
                  ERROR 1215 (HY000): Cannot add foreign key constraint
                  

                  推荐答案

                  CREATE TABLEFOREIGN KEY的语法结构如下:

                  FOREIGN KEY (index_col_name)
                          REFERENCES table_name (index_col_name,...)
                  

                  所以你的 MySQL DDL 应该是:

                  So your MySQL DDL should be:

                   create table course (
                          course_id varchar(7),
                          title varchar(50),
                          dept_name varchar(20),
                          credits numeric(2 , 0 ),
                          primary key (course_id),
                          FOREIGN KEY (dept_name)
                              REFERENCES department (dept_name)
                      );
                  

                  另外,在department表中dept_name应该是VARCHAR(20)

                  更多信息可以在 MySQL 文档中找到

                  More information can be found in the MySQL documentation

                  这篇关于MySQL:错误 1215 (HY000):无法添加外键约束的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to delete duplicate records in mysql database?(如何删除mysql数据库中的重复记录?)
                  Python Pandas write to sql with NaN values(Python Pandas 使用 NaN 值写入 sql)
                  MySQL Insert amp; Joins(MySQL 插入 amp;加入)
                  MySQL concat() to create column names to be used in a query?(MySQL concat() 创建要在查询中使用的列名?)
                  NodeJS responded MySQL timezone is different when I fetch directly from MySQL(当我直接从 MySQL 获取时,NodeJS 响应 MySQL 时区不同)
                  WHERE datetime older than some time (eg. 15 minutes)(WHERE 日期时间早于某个时间(例如 15 分钟))
                    <tbody id='ovqvz'></tbody>
                  • <bdo id='ovqvz'></bdo><ul id='ovqvz'></ul>

                        • <i id='ovqvz'><tr id='ovqvz'><dt id='ovqvz'><q id='ovqvz'><span id='ovqvz'><b id='ovqvz'><form id='ovqvz'><ins id='ovqvz'></ins><ul id='ovqvz'></ul><sub id='ovqvz'></sub></form><legend id='ovqvz'></legend><bdo id='ovqvz'><pre id='ovqvz'><center id='ovqvz'></center></pre></bdo></b><th id='ovqvz'></th></span></q></dt></tr></i><div id='ovqvz'><tfoot id='ovqvz'></tfoot><dl id='ovqvz'><fieldset id='ovqvz'></fieldset></dl></div>

                          <small id='ovqvz'></small><noframes id='ovqvz'>

                            <tfoot id='ovqvz'></tfoot>

                            <legend id='ovqvz'><style id='ovqvz'><dir id='ovqvz'><q id='ovqvz'></q></dir></style></legend>