MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Home Next »

MySQL is the most popular Open Source Relational SQL Database Management System.

MySQL is a database system used on the web and runs on a server

MySQL uses standard SQL and compiles on many platforms and with many languages including PHP, PERL, C, C++, JAVA, etc.

MySQL is fast, scalable, and easy to use database management

MySQL is commonly used in conjunction with PHP scripts for creating powerful and dynamic server-side or web-based enterprise applications.

MySQL is very friendly to PHP, the most appreciated language for web development.

We can query our database in several ways

User can access data from a relational database management system

Allows users to describe the data

Allows users to define the data in the database

Allows users to create and drop database and table

Allows users to create a view, stored procedure, function in a database.

Allows users to set permission on tables, procedures, and views

Allows users to retrieve, insert records, update records, delete records in database

RDBMS stands for Relational Database Management System

RDBMS is the basis for MySQL

Relational database means the data is stored as well as retrieved in the form of relations (tables).

let us revise a few definitions related to the database.

Database − A database is a collection of tables, with related data.

Table − A table is a matrix with data.

Column − One column (data element) contains data of one and the same kind

Row − A row (= tuple, entry or record) is a group of related data

Primary Key − A primary key is unique. A key value can not occur twice in one table. With a key, you can only find one row.

Foreign Key − A foreign key is the linking pin between two tables.

Index − An index in a database resembles an index at the back of a book.

Referential Integrity − Referential Integrity makes sure that a foreign key value always points to an existing row.

The standard MySQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP.

Before you begin this tutorial, you should have a basic knowledge of the information covered in our PHP and HTML tutorials.

We recommend you check our PHP Tutorial for your reference.

MySQL is a relational database management system (RDBMS) based on the SQL (Structured Query Language) queries.

The following are the most important features of MySQL:

MySQL is a relational database management system.

MySQL is easy to use.

MySQL consists of a solid data security layer that protects sensitive data from intruders.

MySQL follows the working of a client/server architecture.

MySQL is free to use so that we can download

MySQL supports multi-threading that makes it easily scalable

MySQL is considered one of the very fast database languages,

MySQL supports a large number of embedded applications,

MySQL allows transactions to be rolled back, commit, and crash recovery.

MySQL is faster, more reliable, and cheaper

MySQL uses Triggers, Stored procedures, and views that allow the developer to give higher productivity.

« Home Next »

C++ Tutorial	CSS Tutorial	C# Tutorial	PHP Tutorial
Java Tutorial	SQL Tutorial	JQuery Tutorial	MySQL Tutorial
HTML - Tutorial	Node.Js Tutorial	JavaScript Tutorial	Python Tutorial
MySQL Installation	Node.js Installation	XAMPP -- Installation	Python Installation
C++ - Environment Setup	Java - Environment Setup	C# - Environment Setup	Responsive Web Design

MySQL Tutorial

What MySQL does

RDBMS

RDBMS Terminology

MySQL Commands

MySQL Features