本文介绍了如何使用 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 在具有外键的表中插入值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！