What are SQL DML commands?

What are SQL DML commands?

SQL DML commands are used to manipulate data in a database. They include operations like INSERT, UPDATE, DELETE, and SELECT.

Can you give me an example of an INSERT command?

Sure! An example of an INSERT command is: INSERT INTO employees (name, age) VALUES ('John Doe', 30); This adds a new employee to the table.

What about an UPDATE command?

An UPDATE command modifies existing records. For example: UPDATE employees SET age = 31 WHERE name = 'John Doe'; This changes John's age to 31.

How do I delete a record?

To delete a record, you can use the DELETE command. For example: DELETE FROM employees WHERE name = 'John Doe'; This removes John Doe from the table.