MySQL

MySQL is a database software server, or call it Smart Database. This database is becoming increasingly popular. By using this database, the data more secure and efficient. This database is also widely used in web database so the data is increasingly integrated with desktop database web database. To use the MySQL database should install it first to your computer.

MySQL Privileges As a database server with the concept of modern databases, MySQL has a privilege. Some of the features MySQL is owned as follows :
1). Portability MySQL database to function with stable without constraints, mean force on various operating systems like Windows, Linux, FreeBSD, Mac OS X Server, Solaris, Amiga, HP-Unix, and others.
2). Open Source MySQL is a database of open source (free), under the GPL license so it can obtain and use them for free.

3). Multi User MySQL is a database that can be used to handle multiple users at the same time without having problems. And allows a MySQL database server can be accessed simultaneously client as well.
4). Performace Tuning MySQL has a pretty good speed in dealing with simple queries, and be capable of processing more SQL per unit time.
5). Column Type MySQL database is supported with very complex data types, such as signed / unsigned integer, float, double, char, varchar, text, blob, data, time, datetime, timestamp, year, set and enum.
6). Command and Functions MySQL server has full service and functionality that support the SELECT and WHERE commands in the query.
  
7). Security Security Systems in MySQL has several layers of security such as levels Subnet, host, and permits the user access to a detailed licensing system and encrypted passwords.
8) Scalability and Limits MySQL has the ability to handle large-scale databases, with the number of records more than 50 million and 60 thousand and 5 billion row table. Moreover, it can accommodate up to 32 index on each table.
9). Connectivity The ability to connect to the MySQL client using TCP / IP, Unix socket (Unix), or Named Pipes (NT).
10). Localization The ability to detect an error (error code) on the client uses more than twenty languages.
11). Interface MySQL has an interface to various applications and programming languages ​​using the function API (Application Programming Interface).
12). Clients and Tools MySQL database has various tools that can be used for database administration.
13). Table Structure MySQL has a table structure is good enough and flexible enough, for example when dealing with alter table.