Database Reference
In-Depth Information
[applied]
-----------
True
SELECT * FROM update_demo;
id | movies | name
----+-------------------------------+------
10 | ['Star Wars', 'Donnie darko'] | null
1 | ['Beautiful Mind', 'Amelie'] | null
(2 rows)
# Delete the whole row when columns are not specified
DELETE FROM update_demo WHERE id = 10;
SELECT * FROM update_demo;
id | movies | name
----+------------------------------+------
1 | ['Beautiful Mind', 'Amelie'] | null
