Scribd
Upload
3 views1 page

MySQL DML Commands Tutorial

The document outlines an experiment aimed at using Data Manipulation Language (DML) commands in MySQL. It details the necessary hardware and software requirements, explains the types of DML commands (INSERT, UPDATE, DELETE, SELECT), and provides a brief procedure for executing these commands. The conclusion emphasizes the learning outcomes related to the use of DML in database management.

Uploaded by

Chandra sekhar Jena
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 views1 page

MySQL DML Commands Tutorial

The document outlines an experiment aimed at using Data Manipulation Language (DML) commands in MySQL. It details the necessary hardware and software requirements, explains the types of DML commands (INSERT, UPDATE, DELETE, SELECT), and provides a brief procedure for executing these commands. The conclusion emphasizes the learning outcomes related to the use of DML in database management.

Uploaded by

Chandra sekhar Jena
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

(1)Aim of the Experiment-: Use of DML command using My sql

(2) Requirements:
Hardware: CPU, Monitor, Keyboard, Mouse, UPS
Software: Windows10/11, MySql 5.1/5.5 COMMAND LINE CLIENT
(3) Theory:

DML stands for Data Manipulation Language.


I t consists of SQL commands that can be used for insert , display and deleting ,and update
table in the database.

Types of DML Commands


INSERT adds fresh data to a table.
UPDATE Change the data that is already in a table.
DELETE -remove a record out of a table.
SELECT display out of one or more records in tables.

INSERT Command
This command is used to enter the information or values into a row
UPDATE Command
This command is used to alter existing table records. Within a table, it modifies data from one or more
records. This command is used to alter the data which is already present in a table.
DELETE Command
It deletes all rows from a table. This command is used to erase some or all of the previous table's
records.
SELECT Command
This command is used to get data/display out of the table

(4) Procedure-:
1. Click on start-> mysql command line client.
[Link] command line will be opened.
3. Write the following code here.

(5).Output: Attach the output as given

(6)conclusion : from the above experiment we knew how to _(aim of


experiment)___________

You might also like