Thursday, November 10, 2011

What is MySQL

SQL (Structured Query Language) is the standard language used to access the server database.Semenjak the 70's language has been developed by IBM, which is then followed by the Oracle, Informix and Sybase. 
By using SQL, database access process becomes moreuser-friendly compared to eg dBase or Clipper is still using the command - the command of pure programming.In addition to MySQL, there are several types of programming-orienteddatabase that can be used for applications on the web such as ORACLE. Oracle is a large company in the world that one business coverage is selling software and making database software, which is applied for large companies in the world. Because the software is not free in "Market" or not free software then most small companies or medium or web programmers are still using MySQL database as database software company or web.The latest news reported that ORACLE is a company that The biggest benefit in business database software.    MySQL is a multi-user SQL database server and multi-threaded.SQL itself is one of the most popular database language in the world.Implementation of this program is a database server daemon program 'mysqld' and several other programs as well as some libraries.     MySQL created by TcX and has been trusted to manage the system with 40 pieces database contains a table 10.000 and 500 of whom had 7 million lines (approximately 100 gigabytes of data). This database is made for the purposes of database systems fast, reliable and easy to use. Although it has sufficient ability good, 
     MySQL for the Unix operating system is freeware, and there are versions shareware for windows operating system. According to its maker, called MySQL like "my-ess-que-ell" and not my-sequel! As with other database systems, also known hierarchy in SQL servers with databases. Each database has tables. Every-each table has fields.Generally, the information stored in the table - a table that is logically two-dimensional structure consists of rows and kolom.Field-field can be data such as int, char realm, date, time and others.SQL does not have a complete programming facilities, there is no looping or branching, for example. So to cover up these weaknesses need to be combined with programming languages ​​such as C.
Advantages of MySQL



  1. MySQL is a multi-threaded programs, so it can be installed on a server that has a multi-CPU.
  2. Supported public programs such as C, C + +, Java, Perl, PHP, Python, TCL APIs DLS.
  3. Work on various platforms. (Available different versions for different operating systems).
  4. Have a column type that pretty much making it easier for system configuration database.
  5.  Having a good security system with a verification host.
  6.  Supports ODBC for Microsoft Windows operating system.
  7. Supports records that have a column with fixed length or variable length. and many other advantages
  8. MySQL is a free software, and can be downloaded at www.mysql.com.While others such as ORACLE database software is software that must be purchased.
  9. MySQL and PHP integrated with each other. The point isdatabase creation using PHP syntax can be made. While the inputs are entered via a web application that uses server-side script such as PHP can be directly inserted into an existing MySQL database on the server and of course the web is located on a web server.

0 komentar:

Post a Comment