MySQL is a database management system for web servers. It can grow with the website as it is highly scalable. Most of the websites today are powered by MySQL.

• MySQL is written in C and C++, and its SQL parser is written in yacc.

Images can be stored in the MySQL database by converting them to BLOBS. But it is not preferred due to the large overhead it creates. Plus, it puts unnecessary load on the RAM while loading the entire database. It is hence preferred to store the paths in the database and store the images on disk.

Importing database in MySQL is a process of moving data from one place to another place. It is a very useful method for backing up essential data or transferring our data between different locations. For example, we have a contact book database, which is essential to keep it in a secure place. So we need to export it in a safe place, and whenever it lost from the original location, we can restore it using import options.
In MySQL, we can import a database in mainly two ways:

• Command Line Tool
•  MySQL Workbench

We can connect two or more tables in MySQL using the JOIN clause. MySQL allows various types of JOIN clauses. These clauses connect multiple tables and return only those records that match the same value and property in all tables. The following are the four easy ways to join two or more tables in MySQL:

• Inner Join
• Left Join
• Right Join
• Cross Join

If we want to manage a database in MySQL, it is required to see the list of all user’s accounts in a database server. The following command is used to check the list of all users available in the database server:

• mysql> SELECT USER FROM mysql.user;

• TRUNCATE is a DDL command, and DELETE is a DML command.
• It is not possible to use Where command with TRUNCATE QLbut you can use it with DELETE command.
• TRUNCATE cannot be used with indexed views, whereas DELETE can be used with indexed views.
• The DELETE command is used to delete data from a table. It only deletes the rows of data from the table while truncate is a very dangerous command and should be used carefully because it deletes every row permanently from a table.

1. MySQL is not so efficient for large scale databases.
2. It does not support COMMIT and STORED PROCEDURES functions version less than 5.0.
3. Transactions are not handled very efficiently.
4. The functionality of MySQL is highly dependent on other addons.
5. Development is not community-driven.

• The top layer contains the services most network-based client/server tools or servers need such as connection handling, authentication, security, and so forth.
• The second layer contains much of MySQL’s brains. This has the code for query parsing, analysis, optimization, caching, and all the built-in functions.
• The third layer contains the storage engines that are responsible for storing and retrieving the data stored in MySQL.

One can view all the databases on the MySQL server host using the following command:

• mysql> SHOW DATABASES;