MYSQL

WHAT IS MYSQL?

MySQL is a fast, easy to use a relational database. It is currently the most popular open-source database. It is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications. MySQL is used for many small and big businesses. It is developed, marketed and supported by MySQL AB, a Swedish company. It is written in C and C++.


MySQL Features:

  • Relational Database Management System (RDBMS): MySQL is a relational database management system.

  • Easy to use: MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements.

  • It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.

  • Client/ Server Architecture: MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, the query data, save changes, etc.

  • Free to download: MySQL is free to use and you can download it from MySQL official website.

  • It is scalable: MySQL can handle almost any amount of data, up to as much as 50 million rows or more. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data.

  • Allows roll-back: MySQL allows transactions to be rolled back, commit and crash recovery.

  • High Performance: MySQL is faster, more reliable and cheaper because of its unique storage engine architecture.

  • High Flexibility: MySQL supports a large number of embedded applications which makes MySQL very flexible.

  • High Productivity: MySQL uses Triggers, Stored procedures and views which allows the developer to give a higher productivity.