Monday, December 10, 2018

What is MySQL?


With PHP, you can connect to and manipulate databases. MySQL is the most popular database system used with PHP.

What is MySQL? 
 MySQL is a database system used on the web
 MySQL is a database system that runs on a server
 MySQL is ideal for both small and large applications
 MySQL is very fast, reliable, and easy to use
 MySQL uses standard SQL
 MySQL compiles on a number of platforms
 MySQL is free to download and use
 MySQL is developed, distributed, and supported by Oracle Corporation
 MySQL is named after co-founder Monty Widenius's daughter: My 

The data in a MySQL database are stored in tables. A table is a collection of related data, and it consists of columns and rows.
Databases are useful for storing information categorically. A company may have a database with the following tables:
 Employees
 Products
 Customers
 Orders 
PHP 5 and later can work with a MySQL database using:
 MySQLi extension (the "i" stands for improved)
 PDO (PHP Data Objects) 
Earlier versions of PHP used the MySQL extension. However, this extension was deprecated in 2012


Post a Comment