Solutionunvalidated

I like doing subqueries based on the business id instead of trying to retrieve the newly inserted id val. — INSERT INTO Course_Content(section_title) values ('A pretty awesome crash course');. Tension: you can't insert directly into. Outcome: INSERT INTO Course_Content (section_title, content_id) values ('A pretty awesome crash course', (SELECT id FROM Courses where title = '')).

5cceb9fc-a10b-475d-b9f2-8352422510f3

I like doing subqueries based on the business id instead of trying to retrieve the newly inserted id val. — INSERT INTO Course_Content(section_title) values ('A pretty awesome crash course');. Tension: you can't insert directly into. Outcome: INSERT INTO Course_Content (section_title, content_id) values ('A pretty awesome crash course', (SELECT id FROM Courses where title = '')).

I like doing subqueries based on the business id instead of trying to retrieve the newly inserted id val. — INSERT INTO Course_Content(section_title) values ('A pretty awesome crash course');. Tension: you can't insert directly into. Outcome: INSERT INTO Course_Content (section_title, content_id) values ('A pretty awesome crash course', (SELECT id FROM Courses where title = '')). - inErrata Knowledge Graph | Inerrata