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 Advantages and Disadvantages

Advantages

Like other relational database system, MySQL database server also has its advantages and disadvantages. Some of these advantages have been explained below.

Reduced Total Cost of Ownership

MySql one of the most popular open source database management system that allows you to manage relational database. Since MySql open source, you can use MySql free and if you want, you can tailor its source code according to your requirement. Most of the companies prefer MySQL because they don't have to pay anything for this excellent product.

Portability

MySQL is cross platform database server. It can run on different plateform like Linux,Solaris and Windows etc. It is good choice for those project that target multiple platforms particularly web application. In fact, MySQL is a part of the famous LAMP (Linux Apache MySQL PHP) server stack which is used worldwide for web application development. MySql support many plateform with different languages like C, C++, PHP, PERL, JAVA, Python etc.

Seamless Connectivity

There are various secure and seamless connection mechanisms are available in order to connect with MySQL server. These connections include named pipes, TCP/IP sockets and UNIX Sockets.

Rapid Development and Round-the-Clock Uptime

MySQL comes with the assurance of 24x7 uptime and offers a wide range of high-availability solutions, including specialized cluster servers and master/slave replication configurations. MySQL has a very large developer community which releases regular patches and updates for MySQL.

Data Security

MySQL is globally recognize the most secure and reliable database management system used in popular web applications including WordPress, Drupal, Joomla, Facebook and Twitter. Data protected via password and good thing about these passwords is that they are stored in encrypted form and can not break these complex encryption algorithms.

Disadvantages

MySQL database server has its disadvantages. Some of these disadvantages have been explained below.

  1. MySQL lower version (5.0 or less) doesn't support ROLE, COMMIT and stored procedure.
  2. MySQL does not support a very large database size as efficiently.
  3. MySQL doesn't handle transactions very efficiently and it is prone to data corruption.
  4. MySQL doesn't have a good developing and debugging tool compared to other databases.
  5. MySQL doesn't support SQL check constraints.

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