Once you have a table, you can insert data into it.
Take the table we created in the previous lesson.
You can now start adding data into it with the INSERT INTO command:
INSERT INTO people VALUES (20, 'Tony')
Once again, click the people table on the sidebar, and you’ll see the data:
You can insert multiple items separating each one with a comma:
INSERT INTO people VALUES (57, 'Joe'), (8, 'Ruby');
If you want to only fill some columns, for example leaving the SERIAL row empty so it automatically fills, you use this syntax:
INSERT INTO people (name) VALUES ('Harry');
Lessons in this unit:
| 0: | Introduction |
| 1: | Using TablePlus |
| 2: | Create a Postgres database |
| 3: | Create a new table |
| 4: | ▶︎ Add data to a table |
| 5: | Query data with SELECT |
| 6: | Delete data from the database |
| 7: | Update data with UPDATE |
| 8: | Null constraints |
| 9: | Unique and primary keys |
| 10: | Updating a table structure |
| 11: | Joins |
| 12: | DEMO Using Vercel Postgres COMING SOON |
Are you intimidated by Git? Can’t figure out
merge vs rebase? Are you afraid of screwing up
something any time you have to do something in
Git? Do you rely on ChatGPT or random people’s
answer on StackOverflow to fix your problems?
Your coworkers are tired of explaining Git to
you all the time? Git is something we all need
to use, but few of us really master it. I
created this course to improve your Git (and
GitHub) knowledge at a radical level. Launching
May 21, 2024. Join the waiting list!