AQA GCSE Computer Science · 8525
Paper 2
Revise: SQL Data Modification and DeletionTwo different changes are possible: UPDATE changes values in existing rows, while DELETE FROM removes whole rows. Neither command creates a new record.
Loading…
Loading…
GCSE Computer Science · key term
An SQL command that changes values in existing rows of a table.
Used by AQA
Paper 2
Revise: SQL Data Modification and DeletionTwo different changes are possible: UPDATE changes values in existing rows, while DELETE FROM removes whole rows. Neither command creates a new record.
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.