SQL Tutorial for Beginners 3: INSERT - Adding Records to Your Database

In this video we will continue learning SQL Basics by inserting records into our table. We will learn the INSERT syntax, a couple of different ways we can add these records, and also what happens if we try to add incorrect values. Let's get started.

✅ Support My Channel Through Patreon:

✅ Become a Channel Member:

✅ One-Time Contribution Through PayPal:

✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot

✅ Corey's Public Amazon Wishlist

✅ Equipment I Use and Books I Recommend:

▶️ You Can Find Me On:

#SQL #Postgres

[hkishawi]

Unfortunately psequel doesn't appear to be supported anymore. But was still able to follow along with tableplus. Solid tutorials dude

[erenbay]

To those who might have made the same mistake, it need be a single quote ', the double quote would show ERROR: column blablabla does not exist

[binyaj]

I am following your tutorials using pgAdmin4 Query Tool on Windows in 2019 !!! Yipee!!!!
Thank

[rickyandreas]

dear Corey, please make tutorial about database with python, thanks Corey!

[wawihabouba]

thank you for this video, could you show me how to create new type and how can I use it

[andyn]

Do you have to insert the rows in a top to bottom order or can you insert the rows randomly? for example first entering row 3, then row 2 and at last row 1?

[taur]

Appreciate the tutorial. Unfortunately Postgres isn't working as seamless on my mac as it is in the video.

[ershadramezani]

I add id and name as you mentioned but it won't appear in the table

[harjoytsandhu]

Hi,

I keep getting
ERROR: syntax error at or near "INSERT"
LINE 5: INSERT INTO staff.VALUES (1, "test");
^
Error

ERROR: syntax error at or near "INSERT"
SQL state: 42601
Character: 69

Why is this ? Please help ?