Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by Mike Hansen
Mike Hansen
293 Points

** IN A HURRY ** Updating information in SQL based on new information coming in

Hi first i wanna say that i'm completely new to SQL, so i'm in a hurry, i need to make a function where i have a movie database, and i have then created a table called "NewMovies" where i wanna make a statement that tells the script to put all the new movies into that database table, i'm kinda lost on how to do this and have to deliver it pretty soon. So any help is appreciated! :)

Christof Baumgartner
Christof Baumgartner
20,864 Points
Christof Baumgartner
Christof Baumgartner
20,864 Points

What kind of database are you using (MySQL, Oracle, etc)?

Mike Hansen
Mike Hansen
293 Points

i am using Microsoft SQL

David Wright
David Wright
4,437 Points

I would recommend watching the videos in Andrew's course, Modifying Data with SQL (perhaps start with his basics course). Modifying Data with SQL goes over how to INSERT data into an existing table, as well as other relevant CRUD statements (Create, Read, Update, Delete) that you'll find useful.

That should at least give you as start. Both of these introductory courses are easy to fly through in an evening or two. On Andrew Chalkey's other courses he goes into more detail; he also has some helpful CheatSheets on his Github, so check out the links to that in his teacher's notes (underneath the videos -- https://github.com/treehouse/cheatsheets/blob/master/modifying_data_with_sql/cheatsheet.md).

You will also want to look at some of the documentation for how Microsoft SQL differs from SQLite (they are very similar for the most part).

Good Luck Mike!