MySQL
MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.
MySQL Database
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons −
* MySQL is released under an open-source license. So you have nothing to pay to use it.
* MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
* MySQL uses a standard form of the well-known SQL data language.
* MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
* MySQL works very quickly and works well even with large data sets.
* MySQL is very friendly to PHP, the most appreciated language for web development.
* MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
* MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.
In order to access data within the MySQL database, all programs and users must use Structured Query Language(SQL). SQL is the set of commands that is recognized by all RDBMSs. It is a language that enables you to create and operate on relational databases, which are sets of related information stored in tables.
Classification of MySQL Statements:
MySQL commands mainly divided into the following categories:
(i) Data Definition Language commands (DDL)
Commands that allow you to perform tasks related to data definition. DDL commands help to create the structure, modify the structure of an existing table, or permanently delete the structure of the table from the database. DDL commands are all auto-commit commands.
For example Create table, Alter table, Drop table, Truncate table.
(ii) Data Manipulation Language commands(DML)
DML commands help us to query the table, insert new data , modify the existing data and if required delete the existing data from the table.
For example: Insert into, Delete, Update
(iii) Data Query Language commands(DQL)
DQL commands help us to query the table and fetch the data as per requirement.
For example select
(iv) Transaction Control Language Commands(TCL)
Helps us to make the changes permanent or undo the changes.
Commands: Commit, Rollback
(v) Data Control Language Commands(DCL)
Helps us to give permissions of an object to other users.
Commands: Grant, Revoke.
