Start Learn PHP/MYSQL : What Is MySQL ? Why MySQL ?

MySQL is the most popular database system used with PHP. MySQL is an open-source relational database management system (RDBMS). In July 2013, it was the world's second most widely used RDBMS, and the most widely used open-source client–server model RDBMS It is named after Michael Widenius' (who is a co-founder of MySQL) daughter, My, while "SQL" stands as the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.

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

PHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform)
Definition And Features
MySQL is a relational database system. MySQL is faster, more reliable, and Free , better than any other database system (including commercial systems such as Oracle and DB2).We can safely say that there is a large bandwidth of opinion.
There is an ever increasing number of MySQL users, and majority of them are quite satisfied with MySQL.
Its also that MySQL still lacks a number of features that are taken for granted with other database systems. If you require such features, then MySQL is not the database system for you.
Features of MySQL
The following list shows the most important properties of MySQL. This section is directed to the reader who already has some knowledge of relational databases. We will use some terminology from the relational database world without defining our terms exactly. On the other hand, the explanations should make it possible for database novices to understand to some extent what we are talking about.
Relational Database System: Like almost all other database systems on the market, MySQL is a relational database system.
Client/Server Architecture: MySQL is a client/server system. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc. The clients can run on the same computer as the server or on another computer (communication via a local network or the Internet)
Almost all of the familiar large database systems (Oracle, Microsoft SQL Server, etc.) are client/server systems. These are in contrast to the file-server systems, which include Microsoft Access, dBase and FoxPro. The decisive drawback to file-server systems is that when run over a network, they become extremely inefficient as the number of users grows.
Why MySQL?
Many of the world's largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.
Type Of Query Example:
Create Statement:Use To Create Database and Tables

CREATE DATABASE dbname;

For Tables:

CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... );

Alter Statement:is used to add, delete, or modify columns in an existing table
To add a column in a table, use the following syntax:

ALTER TABLE table_name ADD column_name datatype

To delete a column in a table:

ALTER TABLE table_name DROP COLUMN column_name

To change the data type of a column in a table:

ALTER TABLE table_name ALTER COLUMN column_name datatype

Insert Statement:is used to add new records to a MySQL table

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

Update Statement:is used to update existing records in a table

UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value

Delete statement: is used to delete records from a table

DELETE FROM table_name WHERE some_column = some_value

Select Statement:Its Use Display all the data From Table

SELECT * FROM table_name