Data Query Language in MySql

Data Query Language is used to extract data from the database. It doesn't modify any data in the database. It describes only one query: SELECT. The DQL statements are the most used statements in SQL language. DQL statements

• select

• Select all the data from the table

select * from table_name;

• Select only some data from the table

select column1,column2 from table_name;