×

  PHP

Introduction Getting Started Data Types Operators Conditional Statements Loops Functions Arrays Include Files GET and POST

  Mysql

Data Base Concepts Mysql Talking to Mysql

  PHP & Mysql

Connect DB Mysql insert Mysql select Mysql update Mysql delete
XAMPP Lite S/W
☰




Introduction to MySQL

MySQL is a relational database server that supports the well-known SQL (Structured Query Language) database language. Therefore, MySQL is named after the language that developers use to store, query, and later update data in a MySQL database. In short, SQL is the native language of MySQL.

SQL (Structured Query Language) is a database language used for formulating statements processed by a database server.

A database consists of some collection of persistent data that is used by the application systems of some given enterprise and managed by a data base-management system.

A database server is a collection of programs that enables users to create and maintain a database.

Commands are relayed to a database server with the help of special languages, called database languages. Users enter commands, also known as statements, that are formulated according to the rules of the database language, using special software; the database server then processes these commands. An example of such a language is SQL.

MySQL is one of the most popular relational database system being used on the Web today. It is freely available and easy to install, however if you have installed Wamp server it already there on your machine.

MySQL database server offers several advantages:

• MySQL is easy to use, yet extremely powerful, fast, secure, and scalable.

• MySQL runs on a wide range of operating systems, including UNIX or Linux, Microsoft Windows, Apple Mac OS X, and others.

• MySQL supports standard SQL (Structured Query Language).

• MySQL is ideal database solution for both small and large applications.

• MySQL is developed, and distributed by Oracle Corporation.

• MySQL includes data security layers that protect sensitive data from intruders.

MySQL database stores data into tables like other relational database. A table is a collection of related data, and it is divided into rows and columns.

Each row in a table represents a data record that are inherently connected to each other such as information related to a particular person, whereas each column represents a specific field such as id, first_name, last_name, email, etc. The structure of a simple MySQL table that contains person's general information may look something like this: