DML commands

DML commands are a set of commands used to directly modify the structure and content of a database. They allow users to create, alter, delete, and retrieve...

DML commands are a set of commands used to directly modify the structure and content of a database. They allow users to create, alter, delete, and retrieve data from and within a database.

Examples:

CREATE TABLE command is used to define a new table with specific columns and data types.

sql

CREATE TABLE students (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

age INT NOT NULL

);

INSERT INTO command is used to add new rows of data to a existing table.

sql

INSERT INTO students (name, age) VALUES ('John Doe', 25);

UPDATE command is used to modify existing rows of data.

sql

UPDATE students SET name = 'Jane Doe' WHERE id = 1;

DELETE command is used to remove rows of data from a table.

sql

DELETE FROM students WHERE id = 3;

SELECT command is used to retrieve data from a table.

sql

SELECT id, name, age FROM students;

By using DML commands, users can perform a variety of tasks on a database, such as creating new tables, adding data, modifying existing data, and retrieving data