Scribd
Upload
46 views6 pages

DML Statements With Examples

DML, or Data Manipulation Language, encompasses SQL statements such as SELECT, INSERT, UPDATE, and DELETE, which are used to manipulate data in a database. Examples include selecting records from a table, inserting new values, updating existing records based on conditions, and deleting records. Each statement serves a specific purpose in managing data within a database system.

Uploaded by

Temp Coding
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
46 views6 pages

DML Statements With Examples

DML, or Data Manipulation Language, encompasses SQL statements such as SELECT, INSERT, UPDATE, and DELETE, which are used to manipulate data in a database. Examples include selecting records from a table, inserting new values, updating existing records based on conditions, and deleting records. Each statement serves a specific purpose in managing data within a database system.

Uploaded by

Temp Coding
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/ 6

DML Statements with examples

DML statements defined…

• DML is short name of Data Manipulation Language.

• Deals with data manipulation, and includes most common SQL


statements such SELECT, INSERT, UPDATE, DELETE etc.

• It is used to store, modify, retrieve, delete and update data in


database.
SELECT statements…
• The SELECT statement is used to select records from the table, with or without a condition.

• Select * from student - Gets all records of student table.

• Select * from student where rank > 5 - Gets records with the condition where students' rank is greater than 5.
Insert statements…
• INSERT statement is used to insert a set of values into a database table. Insert statement it used with Values.

• Insert Into Student (Rank, StudentName, Mark) Values (1,’Abbas’,450)


Update statements…
• The UPDATE statement is used to update existing values in a table, which is based on some condition.

• update student set StudentName=’Abbas’ where StudentName=’Imran’

• The query given above will update the student Name from Imran to Abbas.
Delete statements…
• Delete statement is used to delete the existing record in the table, which is based on some condition.

• Delete from Student where StudentName=’Abbas’

• The query given above will delete records which has StudentName as Abbas.

You might also like