MySQL

MYSQL – MYSQL is top most choice of database for web Development. MYSQL is  top most popular Relational  Database Management System for SQL. Now a days MYSQL is best choice of database for development of Web application.

This tutorial will introduce MYSQL in details in very easy and simple words.

MYSQL Introduction:

What is Database ?

Database is an application which store a collection of data. Database has distinct API for accessing and managing of data. Data storage may be of other type can be used like File system or large hash table but processing of data(mean read and write) is not fast and safe in these type.

PHP5 can work with MYSQL database using

  • MySQLi extension( “i”  for improved)
  • PDO (PHP Data Objects)

Database Management System(DBMS) – DBMS is basically a software which is used to manage the database in a systematic order.

Types of DBMS

RDBMS   – Relational Database Management System

DDBMS    – Ditributed Database Management System

MDBMS     – Mobile Database Management System

OODBMS       – Object Oriented  Database Management System

The Programming language used for Database Management System is Structured  Query Language(SQL) .It is firstally invented by IBM as common language for all the DBMS.

It consists of two types of languages like

  • DDL
  • DML

DDL – Data Definition Languages.It is basically works at table level.

DML – Data Manipulation Language. It is basically works at row level.

 

 

Leave a Comment