如何使用 MySQL 在具有外键的表中插入值? [英] How to insert values in table with foreign key using MySQL?

问题描述

我有这两张表，例如:

TAB_TEACHER
- id_teacher   // primary key, autoincrement
- name_teacher // a varchar

TAB_STUDENT
- id_student    // primary key, autoincrement
- name_student  // a varchar
- id_teacher_fk // foreign key reference to a teacher (TAB_TEACHER)

我想知道这两种情况下如何插入:

I want to know how to insert in these two cases:

CASE 1 - INSERT a new Student with a pre-existing TEACHER，所以我必须获取带有教师姓名的外键

CASE 1 - INSERT a new Student with an pre-existing TEACHER, so I have to get the foreign key with a teacher name

CASE 2 - INSERT a new Student with TEACHER(我在创建学生的同时创建的老师)

CASE 2 - INSERT a new Student with a new TEACHER (the teacher I'm creating in the same time I'm creating the student)

推荐答案

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

对于案例1:

INSERT INTO TAB_STUDENT(name_student, id_teacher_fk)
SELECT 'Joe The Student', id_teacher
  FROM TAB_TEACHER
 WHERE name_teacher = 'Professor Jack'
 LIMIT 1

对于 case2，您只需执行 2 个单独的插入语句

For case2 you just have to do 2 separate insert statements

这篇关于如何使用 MySQL 在具有外键的表中插入值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！