SyntaxFix

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

Case 1

INSERT INTO tab_student (name_student, id_teacher_fk)
    VALUES ('dan red', 
           (SELECT id_teacher FROM tab_teacher WHERE name_teacher ='jason bourne')

it is advisable to store your values in lowercase to make retrieval easier and less error prone

Case 2

mysql docs

INSERT INTO tab_teacher (name_teacher) 
    VALUES ('tom stills')
INSERT INTO tab_student (name_student, id_teacher_fk)
    VALUES ('rich man', LAST_INSERT_ID())

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to insert

• How to insert current datetime in postgresql insert query • How to add element in Python to the end of list using list.insert? • Python pandas insert list into a cell • Field 'id' doesn't have a default value? • Insert a row to pandas dataframe • Insert at first position of a list in Python • How can INSERT INTO a table 300 times within a loop in SQL? • How to refresh or show immediately in datagridview after inserting? • Insert node at a certain position in a linked list C++ • select from one table, insert into another table oracle sql query

Examples related to foreign-keys

• Migration: Cannot add foreign key constraint • The ALTER TABLE statement conflicted with the FOREIGN KEY constraint • Can a foreign key refer to a primary key in the same table? • Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why? • MySQL Error 1215: Cannot add foreign key constraint • MySQL Cannot Add Foreign Key Constraint • Delete rows with foreign key in PostgreSQL • How to remove constraints from my MySQL table? • MySQL - Cannot add or update a child row: a foreign key constraint fails • How to remove foreign key constraint in sql server?