How to insert values in table with foreign key using MySQL?

by

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

For case1:

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

For case2 you just have to do 2 separate insert statements

More Related Contents:

  1. MySQL Creating tables with Foreign Keys giving errno: 150
  2. MySQL Error 1215: Cannot add foreign key constraint
  3. MySQL foreign key constraints, cascade delete
  4. MySQL Conditional Insert
  5. How do I see all foreign keys to a table or column?
  6. MySQL Cannot Add Foreign Key Constraint
  7. Get the new record primary key ID from MySQL insert query?
  8. How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
  9. MySQL – Conditional Foreign Key Constraints
  10. How do I use on delete cascade in mysql?
  11. Increment a database field by 1
  12. Prevent auto increment on MySQL duplicate insert
  13. How to truncate a foreign key constrained table?
  14. MySQL trigger On Insert/Update events
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. Show constraints on tables command
  18. How to add a where clause in a MySQL Insert statement?
  19. Reserved word in column name – insert into MySQL [duplicate]
  20. MySQL Errno 150
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  23. Mysql insert into 2 tables
  24. MySQL – insert data from another table merged with constants
  25. How to remove constraints from my MySQL table?
  26. Foreign key constraints: When to use ON UPDATE and ON DELETE
  27. Insert data into table with result from another select query
  28. MySQL: Insert datetime into other datetime field
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment