How to MySQL- Getting started
In this guide, we are going to learn how to MySQL getting started.
Introduction to database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Databases can be classified according to types of content: bibliographic, full-text, numeric, and images.
SQL stands for structured query language. SQL is the standardized language used to access the database.
SQL has three parts:
Data definition language contains statements that help you define the database and its objects e.g., tables, views, triggers, stored procedures, etc.
Data manipulation language contains statements that allow you to update and query data.
Data control language allows you to grant the permissions to a user to access a certain data in the database.
MySQL is an open-source relational database management system. MySQL is written in C and C++. It was developed by Michael Widenius and David Axmark in 1994. Presently MySQL is maintained by Oracle. MySQL is an important component of LAMP stack, which includes Linux, Apache, MySQL, and PHP.
- MySQL databases are relational.
- MySQL software is Open Source.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
- SQL is an ANSI (American National Standards Institute) standard
- MySQL uses a standard form of the well-known SQL data language.
There are five types MySQL editions.
- MySQL Enterprise Edition
- MySQL Standard Edition
- MySQL Classic Edition
- MySQL Cluster CGE
- MySQL Embedded (OEM/ISV)
There are a lot of third-party free and proprietary graphical administration applications available that integrate with MySQL and users to work with the database.
|phpMyAdmin||Third party, Free, Web-based|
|HeidiSQL||Third party, Free, For Windows|
|Adminer||Third party, Free|
|DBEdit||Third party, Free|
|dbForge GUI Tools||Third party, Free|
|Navicat||Third party, Commercial|
|Maatkit||Third party, Command line, free|
|MySQL Sandbox||Third party, Command line, free|
|SQLBuddy||A free Web-based front end, developed in PHP.|
|SQLyog||Commercial, but a free 'community' edition is available.|
|Toad for MySQL||Third party, free from Quest Software|