MySQL Wildcards

MySQL Wildcards

MySQL Aliases

MySQL Aliases

MySQL Data Types

MySQL Data Types

MySQL Interview Questions

MySQL Interview Questions and Answers


What is MySql?

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 modify its source code as per your need.

This MySql tutorials gives you complete knowledge from basic to advanced level.

MySql is quite easy and simple compare to learn other database like Oracle and SQLServer. You become a MySql master in few days depending on your interest.

You can easily use MySql database for your websites on different plateform like Linux,Unix and Windows. MySQL is an essential component of LAMP stack, which includes Linux, Apache, MySQL and PHP.

Why Use MySql

The following reasons makes MySQL so popular:

  1. MySql is faster compare to other databases even with the large data set.
  2. MySql support many plateform with different languages like C, C++, PHP, PERL, JAVA etc.
  3. MySQL is an open-source database so you don't need to pay a single penny to use it.
  4. MySQL comes under open-source GPL license, you can customiz the cource code for your requirement.
  5. MySQL is very friendly with PHP, the most popular language for web development.
  6. MySQL supports large databases, up to 50 million rows or more in a table.
  7. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) upto a theoretical limit of 8 million terabytes (TB).