In this lesson, we'll cover different ways to manipulate and select data from SQL database tables. In this code along, we'll be creating a cats table in a pets_database.db. So, let's navigate to our ...

I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

Title. Insert into query does not use current database and wants me to specify it explicitly. I assume this is a bug because create table ... as select uses current database correctly. This behaviour ...