SyntaxStudy
Sign Up
Home MySQL Exercises CRUD Operations

CRUD Operations

Beginner

Fill in the MySQL CRUD statement keywords.

To insert a row: INTO users (name, email) VALUES ("Alice", "a@b.com");

To update a row: users SET name = "Bob" WHERE id = 1;

To delete a row: FROM users WHERE id = 1;

To remove all rows but keep the table: TABLE users;