MySQL

This tutorial will teach us different ways to determine storage engine information on the MySQL database server.

Database Metadata is basically ‘data about data’. Relational databases store data in the form of tables. Some examples of MySQL relational database metadata are as follows:

In this tutorial, we will learn about MySQL SHOW ENGINES statement. This command is used to see what storage engines are available on the MySQL Server.

In this tutorial, we will learn about MySQL OUTER JOIN. An INNER JOIN will find combinations of matching rows from joined tables, whereas the OUTER JOIN

In this tutorial, we will learn about MySQL INNER JOIN. A join that identifies combinations of matching rows from two tables is called as an inner join.

The SHOW CREATE VIEW statement shows a CREATE VIEW statement that creates the given view. MySQL statements designed to display the base table information