PostgreSQL Tutorial: How to Update Data in a Table

preview_player
Показать описание
Explore the full SQL & Postgresql Course on Udemy:

In this video you will learn how to:

- Update a row of data in a table.
- Update multiple rows of data in one SQL query.
- Update multiple columns in one SQL query.

#sql
#postgresql
#databases
Рекомендации по теме
Комментарии
Автор

How to update a specific columns only not all column?? How to do it with postgres and nodejs... Anyone pls help??

crunchytreateditz
Автор

I'm sorry, but how update multiple row in one column and in one query ? And the updated values are not the same.

Syubukov
Автор

Small question: I've got name of a column starting with #: #ID_PDQ39. Even though the table is already created, and I'm only changing (updating) the entry, pgadmin doesn't like it and raises an error when I run SET #ID_PDQ39 = 1.

plavali_znaem
Автор

How to extract data permanently ? Like if I want to add new column and put the extracted data from another column?

AngelStephen_