Learning MySql - Overview

MySql

Hello again!
In other post you can learn about Xampp and How to install Xampp, you can check it guys :) . Now i want to give some explanation about MySql. One of many DBMS that exists in this website world.

MySql is a DBMS (Database Management System) that is free-distributed by General Public License (GPL), whereas anybody can use it but not for commercial benefit. MySql is a derivative of Structured Query Language (SQL). SQL is a concept of managing database, which is used to create, change, delete, query of data, that can be done easily and automatically.


These are the superiority of MySql :

1. It can run in many Operating System : Windows, Linux, Mac OS X Server, etc.
2. It is Open Source :)
3. Can be used by multi-user at one time
4. Handling query rapidly
5. Has many complex column type
6. There are several security-layer, like subnet mask, hostname,privilege user
7. Can handle enormous database, with the total field more than 50 million, 60 thousands table, and 5 billion records.

Okay now, we want to know what data types that can run in MySql?
There are so many of data type, here are some of data type that usually used  in MySql :

1. Number Type
• Tinyint : range -128 - 127
• Smallint : range -32768 - 32767
• Mediumint : range -8388608 - 8388607
• Integer/Int : range -2147483648 - 2147483647
• Float/double : Coma number | ex : 3.41
2. Date Type
• Date : format yyyy-mm-dd | ex : 2013-07-01
• Datetime : yyyy-mm-dd hh:mm:ss | ex : 2013-07-01 10:10:10
3. String Type
• Char : Character that have range 1-255 character | ex : a,b,abe
• Varchar : String with length of variable

That's the overview on MySql, in next post we will learn how to create database in mySql and learn how to use that datatype. Stay Tune!