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 […]
MySQL order by – Examples to sort in DESC/ASC order
In This Tutorial 1 MySQL Order by clause 2 Order by MySQL syntax 3 MySQL Order by example 3.1 An order by example with single column in ASC order 3.2 An example of order by in DESC order 3.3 Example of MySQL sort by multiple columns 4 Related MySQL Order […]
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 […]
Learn MySQL delete command in 15 minutes with 3 Demos
Quick Reach 1 The delete query in MySQL 2 MySQL delete query syntax 3 MySQL delete command examples 4 Deleting a row example 5 Delete row example with AND Operator 6 Delete whole table data example 7 Related The delete query in MySQL A few main points about MySQL delete […]
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 […]