MySQL OVERVIEW


php tutorial

   MYSQL DATABASE TUTORIAL

php tutorial

MySQL is RDBMS (Relational Database Management System) and it written in C and C++. It handles as open source and that stores any information called data in database. SQL (Structured Query Language) is used to retrieving as well as manipulate data in database. SQL stands for Structured Query Language, it perform many queries on database that written by user and perform by database engine.


MYSQL HISTORY

Mysql was created by Swedish company and founded by Mr. David Axmark, Allan Larsson and Michael in 1994, it was developed for itself usage from mSQL based on the low-level language ISAM.

Mysql name found by its founder Mr. Michael Widenius’s daughter "My" and SQL acronym stands for Structured Query Language called MySQL.

The Swedish company MySQL AB now owned by Oracle Corporation for proprietary use.

MySQL is very popular choice among various databases for use in web applications, and mysql is a central component of the widely used Lamp open source web application software. Lamp is pronounce as "Linux, Apache, MySQL, Perl/PHP/Python".


FEATURES OF MYSQL DATABASE

FeaturesDefinition
RDBMSMySQL is a relational Database Management System like other databases.
CLIENT SERVER ARCHITECTUREMySQL is a client/server system. Like MySQL Database is a server and arbitrarily many clients (Application Program), Which communicate with the MySQL database server.
SQL COMPATIBILITYThrough configuration setting SQL-Mode we can make the MySQL server behave for the most part compatibly with various database Systems.
VIEWSMySQL has supported views since version 5.0. View is a database object to reduce more sql queries for retrieving information from database.
STORED PROCEDUREStored Procedure is a database object and work for group of Transact-SQL statements that has been created and stored in database.
TRIGGERSMySQL has been supported Trigger limited features since version 5.0 released. Trigger is a database object and excuted by database server when certain event raised like [insert, update, delete] on specified object.

Download MySQL for Your PC