AQA GCSE Computer Science · 8525
Paper 2
Revise: SQL Data Modification and DeletionWHEREselects the row whoseWardNameequals'Victoria'.
Loading…
Loading…
GCSE Computer Science · key term
An SQL clause containing a condition that determines which rows a statement applies to.
Used by AQA
Paper 2
Revise: SQL Data Modification and Deletion
WHEREselects the row whoseWardNameequals'Victoria'.
Use SET for the values to be changed and WHERE for the condition that selects the rows.
DELETE FROM removes whole rows, not just the value in the field mentioned in WHERE.
Check the WHERE condition carefully: omitting it makes UPDATE or DELETE apply to every row.
Create a free account to keep every note you open and track your progress.