MySQL
Where Clause & DML
Title and Content Layout with List
• MySQL Introduction and Commands
• MySQL GUI and Tools
• MySQL – DML Definition and It’s Commands
• MySQL DML Commands and Syntaxes
MySQL Introduction
MySQL is an open-source relational Many of the world's largest and fastest-
database management system growing organizations rely on MySQL
(RDBMS). Its name is a combination of to save time and money powering their
"My", the name of co-founder Michael high-volume Web sites, business-critical
Widenius’s daughter My and "SQL", the systems and packaged software. Such
acronym for Structured Query Language. as:
A relational database organizes data into
one or more data tables in which data may • Facebook
be related to each other; these relations
• Twitter
help structure the data. SQL is a language
programmers use to create, modify and • Booking.com,
extract data from the relational database,
as well as control user access to the • Verizon
database.
SQL Commands
GUI Tool- MySQL Workbench
MySQL Workbench is the integrated environment for MySQL. It was developed by
MySQL AB, and enables users to graphically administer MySQL databases and visually
design database structures. Some of the other GUI tools are:-
Adminer Navicat OpenOffice.org Base SQLyog
Database Workbenc Toad for MySQL Webmin LibreOffice Bas
h e
DBeaver SQLBuddy phpMyAdmin HeidiSQL
The MySQL DML
DML is short name of Data Manipulation
Language which deals with data manipulation
and includes most common SQL statements
such SELECT, INSERT, UPDATE, DELETE, etc.,
and it is used to store, modify, retrieve,
delete and update data in a database.
List of DML commands:
•SELECT: It shows the records of the specified table
•INSERT: It is used to insert data into a table
•UPDATE: It is used to update existing data within a table
•DELETE: It is used to delete records from a database table.
•LOCK: Table control concurrency
•CALL: Call a PL/SQL or JAVA subprogram
•EXPLAIN PLAN: It describes the access path to data
MySQL Select Command...
MySQL Query statement "SELECT" is the most important
data manipulation command in Structured Query
Language. It shows the records of the specified table.
Select Syntax...
SELECT * FROM table_name;
MySQL Insert Command...
MySQL Query statement "INSERT INTO" is
used to insert new records in a table .
Insert Syntax...
INSERT INTO table_name (column, column1,
column2, column3, ...) VALUES (value,
value1, value2, value3 ...)
MySQL UPDATE Command...
MySQL Query statement "UPDATE" is used to
modify data in a table.
Update Syntax...
UPDATE table_name SET column=value,
column1=value1,... WHERE
someColumn=someValue
MySQL Delete Command...
MySQL Query statement "DELETE" is used to
delete data from a database table.
Delete Syntax...
DELETE FROM tableName WHERE someColumn =
someValue
The MySQL WHERE Clause
The WHERE clause is used to filter records.
It is used to extract only those records
that fulfill a specified condition.
Where Syntax...
SELECT column1, column2, ...
FROM table_name
WHERE condition;
Note: The WHERE clause is not only used
in SELECT statements, it is also used in UPDATE, DELETE,
etc.!
Conclusion:
MySQL is a relational database that organizes data based
on the relationships between tables and fields. It is a type
of Relational DataBase Management System (RDBMS),
which stores entries as rows within tables.
Presentation by:
S.M.Zishan Ali
Student: ExcelR
