Author: Krishna

MySQL ORDER BY Clause The MYSQL ORDER BY Clause is used to sort the records in ascending or descending order.

MySQL FROM Clause The MySQL FROM Clause is used to select some records from a table. It can also be

MySQL Distinct Clause MySQL DISTINCT clause is used to remove duplicate records from the table and fetch only the unique

MySQL WHERE Clause MySQL WHERE Clause is used with SELECT, INSERT, UPDATE and DELETE clause to filter the results. It

MySQL SELECT Statement The MySQL SELECT statement is used to fetch data from the one or more tables in MySQL.

MySQL DELETE Statement MySQL DELETE statement is used to delete data from the MySQL table within the database. By using

MySQL UPDATE Query MySQL UPDATE statement is used to update data of the MySQL table within the database. In real

MySQL INSERT Statement MySQL INSERT statement is used to insert data in MySQL table within the database. We can insert

MySQL View In MySQL, View is a virtual table created by a query by joining one or more tables. MySQL

MySQL DROP Table MYSQL DROP table statement removes the complete data with structure. Syntax: DROP TABLE  table_name; Example: DROP TABLE  cus_tbl; MySQL TRUNCATE Table