Answers for "mysql how to insert into a value within a table"

SQL
3

fk in insert mysql

INSERT INTO joke(joke_text, joke_date, author_id)
VALUES (‘Humpty Dumpty had a great fall.’, ‘18990313’, 
        (SELECT id FROM author WHERE author_name = ‘Famous Anthony’));
Posted by: Guest on November-17-2020
2

insert into table from another table mysql

INSERT INTO table1 (emp_id, fname)
SELECT emp_id, fname 
FROM table2
WHERE status = 'Active';
Posted by: Guest on May-31-2020

Code answers related to "mysql how to insert into a value within a table"

Code answers related to "SQL"

Browse Popular Code Answers by Language