Explain how SQL can be used to update data in a database

INSERT INTO, UPDATE, and DELETE are all DML commands. They do not use the TABLE keyword.

• SQL can be used to change the data stored in a database.
• The three main commands are:
  • INSERT INTO
    • adds new records
  • UPDATE
    • changes existing records
  • DELETE
    • removes records

INSERT INTO

INSERT INTO table_name (Attribute1, Attribute2, Attribute3)
VALUES (value1, value2, value3);

UPDATE

UPDATE table_name
SET Attribute1 = value1, Attribute2 = value2
WHERE condition;

DELETE

DELETE FROM table_name
WHERE condition;