Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7

[@malcorub]

My kids have been bugging me to take them to see Inside Out 2... might just have to take them to the drive in this weekend. lol. Awesome 30 day challenge, keep it up!

[@learningwithjelly]

Go see it!!!! Lol and thank you for participating in the challenge

[@dantheman-adadwithchores4857]

I am using version SQLite Studion 3.4.4 - i don't use a semi-colon ";" at the end and it still seems to work.

[@SaraEliBeth90]

Is there any reason you did auto increment versus identity and selecting the number and increment value?

[@learningwithjelly]

Nope multiple ways to do it just chose auto increment for simplicity for beginners here

[@awotundeoluwatosin7427]

I made a mistake when creating my table and used File_Id instead of Film_id. Please How do i Update/ Correct that without creating a duplicate table. Thanks Keep up the good work God Bless

[@learningwithjelly]

For now (since we have not learned updating tables) just rename ID back to File_Id and then Film_Id to ID using a select statement. Or the easiest way for now is to close out of SQLite and reopen it. And correct your code to have the right column and rerun it