How to Delete Record on Postgresql Database

How to Delete Record on Postgresql Database

Hi guys, welcome to my channel fathir habib, in this video I will show you how to delete record on Postgresql database. On this time, I am using the people's table, if you want to see all data in your table, please type select all from peoples, and then execute the query, we can see the contents of the table people.

We can use the DELETE command to delete the record, like the malicious example below,
DELETE FROM peoples ;
Be careful, the example above can delete all records in the people's table , like SELECT and UPDATE, DELETE can also be included with WHERE.

For example, the people's record number WHERE id equal is two will be delete, DELETE from peoples WHERE id equal is two, execute the query, query returned successfully.

SELECT all from peoples, execute the query, see the data id equals is two has been deleted.

Let's we delete again the data where id equals is four, DELETE FROM peoples WHERE id equal is four, and then execute the query, select all from peoples, and then execute the query, see the data id equals is four has been deleted.

So we can conclude the query is DELETE FROM table name WHERE id equals the value of id.

Thanks for watching, don't forget to subscribe, like and share my videos to your friends, see you and bye bye.

Hastag :
#postgresql ,
#postgres,
#postgresqltutorial