How do you insert, update and delete rows?
Model answer
INSERT INTO users (name, email) VALUES ('Asha', 'a@example.com'); UPDATE users SET name = 'Asha K' WHERE id = 1; DELETE FROM users WHERE id = 1; Always include a WHERE clause for UPDATE and DELETE unless you truly mean every row.
Learn this topic
INSERT, UPDATE and DELETE: Change Data Safely in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.