Introduction to MySQL


Share

A database is a structured collection of records or data stored in a computer system and organized in such a way that it can be searched quickly and information can be retrieved rapidly.
The SQL in MySQL stands for Structured Query Language.
This language is loosely based on English and is also used on other databases, such as Oracle and Microsoft SQL Server. It is designed to allow simple requests from a database via commands such as:



SELECT title FROM publications WHERE author = 'Deepak';


A MySQL database contains one or more tables, each of which contains records or rows. Within these rows are various columns or fields that contain the data itself.
All row in the table is the same as a row in a MySQL table, and each element within a row is the same as a MySQL field.
There are three main ways in which you can interact with MySQL: using a command line, via a web interface such as phpMyAdmin, and through a programming language like PHP.


What is MySQL

1. MySQL is a database system used for developing web-based software applications.
2. MySQL used for both small and large applications.
3. MySQL is a relational database management system (RDBMS).
4. MySQL is fast, reliable, and flexible and easy to use.
5. MySQL supports standard SQL (Structured Query Language).
6. MySQL was developed by Michael Widenius and David Axmark in 1994.
7. MySQL is presently developed, distributed, and supported by Oracle Corporation.



MySQL main Features

1. MySQL server design is multi-layered with independent modules.
2. MySQL is fully multithreaded by using kernel threads. It can handle multiple CPUs if they are available.
3. CPUs if they are available.
4. MySQL has a high-speed thread-based memory allocation system.
5. MySQL supports in-memory heap table.
6. MySQL Handles large databases.
7. MySQL Server works in client/server or embedded systems.
8. MySQL Works on many different platforms.

MySQL Commands

There are various commands available in MySQL:

ALTER, BACKUP, CREATE, DELETE, DESCRIBE, DROP, EXIT (Ctrl-C), GRANT, INSERT, LOCK, RENAME, SHOW, SOURCE, UPDATE etc.


1. SQL commands and keywords are case-insensitive. CREATE, create, and CrEaTe all mean the same thing. However, for the sake of clarity, the recommended style is to use uppercase.

2. Table names are case-insensitive on Windows, but case-sensitive on Linux and OS X. So, for portability purposes, you should always choose a case and stick to it. The recommended style is to use lowercase or mixed upper- and lowercase for table names.