MySQL was developed by a Swedish company called MySQL AB, which was then named TcX DataKonsult AB, since about 1994-1995, although the code can be called the forerunner has existed since 1979. First goal TcX make MySQL at that time also was to develop a Web application to client-TcX is a software developer and database consultant. At that time Michael Widenius, or "Monty", the developer only in TcX, has UNIREG applications and ISAM routine made themselves and are looking for an SQL interface to be attached to it.
At first TcX using mSQL, or "mini-SQL" (we'll visit later). Perhaps mSQL is the only open source database code available and simple enough at the time, although there are Postgres (also to be discussed shortly). But apparently, according to Monty, mSQL was not fast enough or flexible. The first version of mSQL does not even have an index. After trying to contact David Hughes-mSQL-makers and actually knew that David was busy developing two versions, the decision taken by Monty is making your own SQL engine interface similar to mSQL but has more capabilities as needed. MySQL born.
Name MySQL (read: mai és kju él) is clearly taken from where. Some say this is taken from the first and last letters nicknames Michael Widenius, Monty. There is another who says the word My daughter named Monty, who was given the name My-because Monty was originally a Finnish. But the fact that the source code of MySQL glance, my prefix is already terbubuhi everywhere-prefix is often a common prefixes if a person makes its own custom code for something. If you really wonder which one is correct, it may be asked directly to Monty.
MySQL version 1.0 was released in May 1996 are limited to four people. New in October 3.11.0 version released to the public. But first the code is not provided under the General Public License license, but a special license that essentially something like this: "Source code can be viewed and free MySQL and the MySQL server can be used without charge but only for non-commercial use. For commercial use (eg, package and sell MySQL, or MySQL included in other commercial programs) you have to pay for a license. "While the Windows distribution of MySQL was released in shareware. It was only in June 2000 MySQL AB announced that since the version of 3:23:19, MySQL is free software licensed under the GPL. That is, "MySQL Source code can be viewed for free, as well as the MySQL server can be used at no cost for any need. But if you modify the source code, you also have to take it off under the same license, the GPL. "Now the company MySQL AB, which consists of about 10 programmers and 10 other employees that earn income primarily from consulting services around MySQL.
The first public version, which only runs on Linux and Solaris, and remains largely undocumented, with gradually improved and added features to features-but still with a primary focus on slimness and speed development. That is, the feature that causes a slow MySQL is not added, or put on hold, or added but a feature that is optional.
This initial version of MySQL, though it can be used for simple Web applications, is not enough at all for business applications. For example, a simple JOIN already exist, but no HAVING recently added in December. There is already a TIMESTAMP data type and column AutoUpdate, but no system-generated number (sequence)-new in late 1996 also added modifier AUTO_INCREMENT column. Already there LIMIT but GROUP BY and ORDER BY has limitations. And so on.
It was only in the final versions of the 3:22-long 1998-1999-MySQL is becoming increasingly popular and see people. Stability is good. Velocity increases. It is available in a variety of platforms, including Windows. 3:22 Series is widely used in a variety of installations, perhaps until now, so that MySQL AB continued to support technical support for this series.
What's Sih MySql??
- MySQL is a database management system. A database is a structured collection of data. The data can be a very simple shopping list to a gallery of paintings or the amount of the amount of information on the corporate network. To add, access and process data stored on a computer database, we need management database such as MySQL.
- MySQL is a database management system are interconnected. A relationship databse of data stored in a separate table rather than storing all data in a very large room. This adds speed and flexibility. Tables are linked by a relationship that has been defined result will be possible to combine data from multiple tables as appropriate.
- MySQL is 'Open Source Software'. 'Open Source' means the program is allowed to be used and modified by anyone. Everyone can download MySQL from the Internet and use it without paying a penny. One can learn the 'Source Code' and can change it according to their needs. MySQL uses the GPL (GNU General Public License).
Why use MySQL?
MySQL is a database that is fast, reliable and easy to use. If that is what you are looking for then you should try it. In addition, any source program you can get for free and the syntax-the syntax is easy to understand and uncomplicated as well as accessing the database can be done easily and quickly.
Excess - excess MySQL
In addition to its Open Source program, MySQL also has advantages that are not less good with other database servers such as SQL Server, Sybase and even Oracle. The advantages include:
=> It can work in several different platforms, such as Linux, Windows, MacOS, etc..
=> Can be connected to the language C, C + +, Java, Perl, PHP and Python.
=> Having more types of data such as: signed / unsigned long integer data for 1,2,3,4 and 8 bytes, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR , SET and ENUM types.
=> Full support for SQL sentence GROUP BY and ORDER BY. Supporting the full function (COUNT (), COUNT (DISTINCT), AVG (), STD (), SUM (), MAX () AND MIN ()).
=> Support for OUTHER LEFT JOIN with ANSI SQL and ODBC syntax.
=> Supports ODBC for Windows 95 (with source code). All functions of ODBC 2.5 and so on. For example, we may use Access to connect to a MySQL server.
=> Use your GNU automake, autoconf, and libtool for portability.
=> We can combine multiple tables from different databases in the same query.
=> Written using C and C + +. Tested by the compiler are very much different.
=> Privilege (right) and a very flexible and secure passwords and mengujinkan 'Host-Based Verification'.
Labels:
Computer,
Hosting And Domain,
Network,
Program Flash
Thanks for reading About MySQL . Please share...!
0 Komentar untuk "About MySQL "