KEMBAR78
Powerpoint Presentation On DML Commands | PDF
Scribd
Upload
603 views9 pages

Powerpoint Presentation On DML Commands

This powerpoint presentation discusses the main DML (Data Manipulation Language) commands in 3 slides. It introduces the INSERT, UPDATE, and DELETE commands. For each command, it provides the syntax, examples of how to use the command, and brief descriptions of how each command works to add, modify, or remove rows from a database table.

Uploaded by

Mohd Arman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
603 views9 pages

Powerpoint Presentation On DML Commands

This powerpoint presentation discusses the main DML (Data Manipulation Language) commands in 3 slides. It introduces the INSERT, UPDATE, and DELETE commands. For each command, it provides the syntax, examples of how to use the command, and brief descriptions of how each command works to add, modify, or remove rows from a database table.

Uploaded by

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

POWERPOINT

PRESENTATION
DML COMMANDS

ON

MADE BY ARMAAN AND


REHAN

* TYPES OF DML COMMANDS


Editing Command
Insert
Update
Delete

Review command
select

1.INSERT COMMAND
Insert is used to add a new row to a table
Can add one or more rows
Syntax varies depanding on numbers

Insert syntax for one row


Insert into table name
Values(value list)

*EXAMPLE OF INSERT
COMMAND

Insert into dept


values(10,"ACCOUNTING","NEW DELHI);

2.Update command
.update is used to change the an existing row.
.Can change one,some or all rows in a table or view
.a where clause is used to specify specific rows to change

UPDATE SYNTAX
Update tablesname
set field1=value1
[Where condition]

*Example of update command


*increase the stipend by 200 whose subject is ip
update result

set stipend = stipend+200


where subject=ip;

3.DELETE COMMAND
Delete

command is used to removes one or more


rows from a table

no field list is included

may specify which row to remove by adding by

adding where clause

* DELETE SYNTAX
Delete from tablename
[where condition]

Not included a where clause removes all rows


From a table

* EXAMPLE OF DELETE
COMMAND

Delete from dept


Where deptno=60;

*delete from dept;

K
N
A
TH
U
YO

You might also like