Scribd
Upload
7 views3 pages

SQL DML Operations Guide

Uploaded by

kazimuskan569
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
7 views3 pages

SQL DML Operations Guide

Uploaded by

kazimuskan569
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/ 3

EXPERIMENT NO.

3
Aim :- Write a program to execute all DML operations.

Software Used :- MYSQL

Theory :-

● DML ( Data Manipulation Language )


The SQL commands that deals with the manipulation of data present in
the database belong to DML or Data Manipulation Language and this
includes most of the SQL statements. It is the component of the SQL
statement that controls access to data and to the database. Basically, DCL
statements are grouped with DML statements.

● List of DML commands:


1. INSERT – It is used to insert data into a table.
2. UPDATE - It is used to update existing data within a table.
3. DELETE - It is used to delete records from a database table.

Conclusion :- Hence we implemented the DML operations in MYSQL.


Output Screenshots :-
i) Insert
ii)
Update:

iii.Delete:

You might also like