Introduction of MySQL in PHP

Introduction of MySQL

• ·       A relational database management system software.
• ·       Open-source database software, which is supported by oracle company.
• ·       Commonly used with PHP for creating powerful and dynamic server-side or web-based enterprise applications.
• ·       Developed, and supported by MySQL ab, (a Swedish company).
• ·       Written in c, and c++ programming language.
• ·       Official pronunciation of MySQL is my ess que ell.
•  

MySQL Features

the most popular languages for accessing and managing the records in the table.

Important features are:-

Relational Database Management System (RDBMS)

• MySQL is a relational database management system. 
• Based on SQL (Structured Query Language) queries to access and manage the records of the table.

Easy to use

Require only basic knowledge of SQL which can build and interact with MySQL by few simple SQL statements.

Client/ Server Architecture

Database server (MySQL) and many clients (application programs), which communicate with the server.

Free to download

MySQL is open-source and free to use simply download from MySQL's official website.

Scalable

MySQL supports multi-threading that makes it easily scalable. It can handle a huge amount of data, up to as much as 50 million rows or more. The file size limit is more than 4 GB.

Speed

MySQL is considered as very fast manage database languages.

High Flexibility

• MySQL supports a large number of embedded applications, which makes MySQL very flexible.
• Compatible on many operating systems (support cross-platform)
• MySQL is compatible to run on many operating systems, like Novell NetWare, Windows Linux, and UNIX etc.
• provides a facility to clients which can run on the same computer as the server or on another computer (communication via a local network or the Internet).

Recovery

MySQL allows transactions to be rolled back, commit, and crash recovery.

Memory efficiency

Its efficiency is high because it has a very low memory leakage problem.

High Performance

• MySQL is faster, more reliable, and cheaper because of its unique storage engine architecture. 
• It has fast loading utilities because of the different cache memory.

High Productivity

MySQL uses Triggers, Stored procedures, and views etc. which allow the developer to give higher productivity.

Platform Independent

Mysql can download, install, and execute on most of the available operating systems.

Partitioning

Partitioning improves the performance and provides fast management of the large database.

GUI Support

• MySQL provides a unified visual database graphical user interface tool named "MySQL Workbench" to work with database architects, developers, and Database Administrators. 
• Use for SQL development, data modeling (Data modeling: - process of creating a data model for database storage. ), data migration (Data migration: - a process of moving data from one location to another, one format to another, or one application to another.), and comprehensive (detailed) administration tools for server configuration, user administration, backup, and many more. 
• MySQL has fully GUI supports from MySQL Server version 5.6 and higher.

Security (Dual Password Support)

MySQL version 8.0 provides support for dual passwords: one is the current password, and another is a secondary password (to transition).  

It uses advanced and complex encryption algorithms.

Open Source and Cost-Effective

It is open-source and it has a free version as well. Code of the software is available.

 Portability

• MySQL is a cross-platform database server. 
• MySQL contains API for easily integrated with the languages like PHP, C++, Perl, C, Python, and Ruby.
• MySQL is a part of the famous LAMP (Linux Apache MySQL PHP).

 Seamless Connectivity

MySQL server provides various secure and seamless connection mechanisms. it includes TCP/IP sockets, and UNIX Sockets and is also used in web applications like WordPress, Drupal, Joomla, Facebook, and Twitter.

Rapid Development and Continuous Updates

MySQL provides several database templates which can be easy used and modified, resulting in rapid application development.

Transactional Support

• MySQL support multi-version transaction support, instant deadlock identification and free row-level locking. 
• MySQL version provides full data integrity to all its users and enforced referential integrity.

 

=====================================================