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.

MySQL Getting Started

SQL

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

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.

ToolsDescription
phpMyAdminThird party, Free, Web-based
HeidiSQLThird party, Free, For Windows
AdminerThird party, Free
DBEditThird party, Free
dbForge GUI ToolsThird party, Free
NavicatThird party, Commercial
MaatkitThird party, Command line, free
MySQL SandboxThird party, Command line, free
SQLBuddyA free Web-based front end, developed in PHP.
SQLyogCommercial, but a free 'community' edition is available.
Toad for MySQLThird party, free from Quest Software

Anwar Yakkiparamban

Anwar Yakkiparamban is the founder of Lauyou Learning. Prior to Lauyou learning, Anwar worked at ARD Engineering & Development, Qatar. He holds bachelor degree in Electronics and Communication Engineering from Govt. Engineering College Idukki.

You may also like...