Information Computer

Tuesday, August 9, 2011


MYSQL is the software used to manage databases or what is often called the Database Management System (DBMS). MySQL is a database software that is usually used in server. MySQL is very popular in web-based programming, primarily in PHP and Perl programming. MySQL is an open source software. although generally very commonly used in Linux, but now that MySQL has been present in Windows. in 2002 and 2001 MySQL get the award as the best database for Linux server version of Linux Magazine and as a favorite database in 2000.

Advantages of MySQL.Column Type

  1. MySQL has a pretty good table structure and flexible.
  2. MySQL server has full service and functionality that support the SELECT and WHERE in the query.
  3. The ability to connect to the MySQL client using TCP / IP, Unix socket (Unix), or Named Pipes (NT).
  4. MySQL can be used to handle multiple users at the same time.
  5. MySQL stable function without constraints.
  6. MySQL has a pretty good speed and capable of processing more SQL per unit time.
  7. Security on the MySQL system has several layers of security such as levels subnetmask, hostname, and permits the user access to a detailed licensing system as well as encrypted passwords
  8. MySQL is a database of open source (free).
  9. MySQL database is supported with a very complex data types.
  10. MySQL database has various tools that can be used for database administration.
  11. MySQL has an interface to various applications and programming languages ​​using the API functions (Application Programming Interface).
  12. The ability to detect an error (error code) on the client uses more than twenty languages.
  13. 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 index on each table.
for how to use MySQL and its query will be discussed in the next post. thank :)

need to know! 
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). This definition is very general, and is independent of the technology used.

The term "database" may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to physical database as data content in computer data storage or to many other database sub-definitions..

Related Posts