MySQL Tutorial

What is MySql
MySQL History
MySQL Advantages & Disadvantages
MySQL Features
Install MySQL Database Server on Window
Install MySQL Database Server on Linux

MySQL Database

Create Database
Select Database
Drop Database
Information About Databases

MySql Table

CREATE Table
ALTER Table
TRUNCATE Table
DROP Table
RENAME Table
TEMPORARY Table

MySQL Queries

INSERT Record
SELECT Record
UPDATE Record
DELETE Record
TRUNCATE Table
SUBQUERY

MySQL Clauses

MySQL WHERE
MySQL DISTINCT
MySQL FROM
MySQL ORDER BY
MySQL GROUP BY
MySQL HAVING
MySQL LIMIT

MySQL Operators

MySQL AND
MySQL OR
MySQL AND OR
MySQL LIKE
MySQL NOT LIKE
MySQL SOUNDS LIKE
MySQL REGEXP
MySQL CASE
MySQL DIV
MySQL MOD
MySQL IN
MySQL NOT
MySQL XOR
MySQL IS NULL
MySQL IS NOT NULL
MySQL BETWEEN
MySQL EXISTS
MySQL NOT EXISTS
MySQL ANY
MySQL ALL
MySQL UNION
MySQL MINUS
MySQL INTERSECT

MySQL Wildcards

MySQL Wildcards

MySQL Aliases

MySQL Aliases

MySQL Joins

MySql Inner Join
MySql Left Join
MySql Right Join
MySql Cross Join
MySql Self Join

MySQL Constraints

MySQL NOT NULL
MySQL UNIQUE
MySQL PRIMARY KEY
MySQL FOREIGN KEY
MySQL CHECK
MySQL INDEX

MySQL Data Types

MySQL Data Types

MySQL Aggregate Functions

MySQL count
MySQL sum
MySQL avg
MySQL min
MySQL max
MySQL first
MySQL last

MySQL Functions

MySQL Control Flow Functions
MySQL String Functions
MySQL Numeric Functions
MySQL Date and Time Functions
MySQL Information Functions
MySQL Cast Functions
MySQL Encryption and Compression Functions
MySQL JSON Function

MySQL Advanced

MySQL Stored Procedure
MySQL View
MySQL Trigger
MySQL Administration

MySQL Programming Interfaces

Python MySQL Tutorial
Perl MySQL Tutorial
Node.js MySQL Tutorial
PHP MySQL Tutorial
MySQL JDBC Tutorial

MySQL Interview Questions

MySQL Interview Questions and Answers


MySQL Features

The following list shows the most important features of MySQL:

  • RDBMS: Like other database systems, MySQL is a compete Relational Database System.
  • Full-text indexing and searching.
  • Its unique storage engine architecture gives very high performance.
  • It support large number of embedded applications which makes MySQL very flexible.
  • By providing Triggers, Stored procedures and views, it improve the developers productivity.
  • Allows transactions to be rolled back, commit and crash recovery.
  • MySQL support client/server Architecture. The clients can run on the same computer as the server or on another computer (communication via a local network or the Internet).
  • Subquery Support: Since version 4.1, MySQL is capable of processing a subquery in the form SELECT * FROM tbl1 WHERE A IN (SELECT Y FROM tbl2)
  • Cross-platform support: MySQL database run on different plateform like Linux,Unix and Windows.
  • MySQL support many plateform with different languages like C, C++, PHP, PERL, JAVA, Python etc.
  • Scalability: MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data.
  • Views: MySQL views relate to an SQL query that is viewed as a distinct database object. MySQL has supported views since version 5.0.
  • Stored procedures: MySQL has support Stored procedures from version 5.0 that deals with SQL code stored in the database system.
  • Triggers: MySQL has supported triggers in a limited form version 5.0. Basically Triggers are SQL commands that are automatically executed by the server in certain database operations (INSERT, UPDATE, and DELETE).
  • Unicode: MySQL has supported all conceivable character sets since version 4.1.
  • User interface: There are a 'N' number of good user interfaces available fo manage a MySQL server.
  • Replication: MySQL has supported replication form version 5.0. Basically replication allows the contents of a database to be copied (replicated) onto a number of computers.
  • Transactions: MySQL has supported transactions form version 5.0. A transaction means the execution of several database operations as a block.
  • Multiple storage engines: MySQL allows you to choose the one that is most effective for each table in the application.

AngularJS Code Examples
AngularJS Live Demo
ASP.NET Code Examples
Javascript Code Examples
Interview Q & A
Google MAP API Live Demo
Google MAP API Code Examples
Utility Tools
Articles