Answers for "how to input a value to a table which has foreign key"

fk in insert mysql

INSERT INTO joke(joke_text, joke_date, author_id)
VALUES (‘Humpty Dumpty had a great fall.’, ‘1899–03–13’, 
        (SELECT id FROM author WHERE author_name = ‘Famous Anthony’));

Posted by: Guest on November-17-2020

Code answers related to "how to input a value to a table which has foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to input a value to a table which has foreign key"

Code answers related to "how to input a value to a table which has foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to input a value to a table which has foreign key"

Code answers related to "how to input a value to a table which has foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us