Scribd
Upload
3 views

DML command

DML command in DBMS

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views

DML command

DML command in DBMS

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Experiment No- 05

AIM: TO PERFORM THE DML (Data Manipulation Language)


COMMAND.
DML: DML stands for Data Manipulation Language, the SQL command that dealing with
the manipulation of data present in the database.
Insert Command: Insert command is one of the most important command in DML which
allows users to insert data in database table.
• Syntax:
INSERT INTO Table name (columnName1, columnName2)
VALUES(‘value1’, ‘value2’);

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025


Update Command: The update command allows users to update or modify the existing data
in the database table.
Syntax: UPDATE Table Name SET (columnNamr1=value1, columnName2=value2) WHERE condition;

Delete Command: The delete command allows user to remove single or multiple existing record from the
database table.

Syntax: DELETE FROM TableName WHERE condition;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025

You might also like