MySQL left join with example

In This Tutorial 1 MySQL left join 2 Left join syntax 3 A left join example 4 Related MySQL left join In order to use joins in MySQL, we normally use at least two tables to fetch data. One table name is given after the select statement while the other […]

MySQL Tutorial

In This Tutorial 1 What is MySQL 2 History of MySQL 3 Usability of MySQL 4 What is SQL 5 Purpose of MySQL tutorial 6 Tutorial examples 7 Download and install MySQL 7.1 Downloading and installing MySQL as part of stack package 8 Table of content of MySQL Tutorial 9 […]

MySQL Select: With 3 online demos

Quick Reach 1 MySQL select statement 2 MySQL Select syntax 3 Select statement examples in MySQL 3.1 Retrieving whole data by select query 3.2 Select statement with column names example 3.3 Select with Where clause example MySQL select statement A few main points about the select command: To retrieve existing […]

Learn to use MySQL inner join with examples

Quick Reach 1 What is inner join of MySQL? 2 Inner join syntax 3 MySQL inner join example What is inner join of MySQL? The inner join is a type of join in MySQL which is mostly used. In that join type, only those rows are returned that are matched […]

5 Examples of MySQL Update Query With Syntax

Quick Reach 1 The update statement of MySQL 2 MySQL Update – Set Syntax 3 An Update example without Where clause 4 An example of using Update – Set with where clause 5 An example with multiple conditions in update statement 6 Multi-column modification example by Update statement 7 Related […]

Right join in MySQL

Quick Reach 1 MySQL right Join 2 Right join syntax 3 A right join example MySQL right Join In right join type of MySQL, all records from the right table, the one after the join clause are fetched. While only the matched rows from the left table are returned. As using the […]

MySQL primary key with 2 examples

Quick Reach 1 What is primary key in MySQL 2 A MySQL primary key example 3 Example of primary key in an existing table What is primary key in MySQL In the previous chapter, we looked at creating MySQL tables. We simply created a table (tbl_employee) for our example with four columns. The […]

MySQL drop database command

Quick Reach 1 Deleting a database of MySQL 1.1 Syntax to use Drop database Deleting a database of MySQL In the last chapter, we learned how to create a MySQL database. To drop a database in MySQL using MySQL command the syntax will be as follows. Syntax to use Drop database […]