Many dynamic websites require a back-end database. The database can contain information that the web pages display to the user, or the purpose of the database might be to store information provided by the user. In some applications, the database both provides available information and stores new information.
How to Select From two Tables in MySQL
In many cases, you often need to get data from multiple tables in a single query. You can use JOIN clause to get data from multiple tables in your single SQL query. A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
Data Types in MySQL
MySQL stores information in different formats. It allows different types of data to be used in different ways. The main types of data are character, numerical, and date and time. When you create a database, you tell MySQL what kind of data to expect in a particular column by using the MySQL names for data types.
MySQL vs MariaDB
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Some of the original developers of MySQL forked it due to concerns over its acquisition by Oracle Corporation. Its lead developer is Michael "Monty" Widenius, one of the founders of MySQL AB. MariaDB is named after Monty's younger daughter Maria, similar to how MySQL is named after his other daughter My.