MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.
- MySQL is released under an open-source license. So you have nothing to pay to use it.
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA etc.
- MySQL works very quickly and works well even with large data sets.
- MySQL is very friendly to PHP, the most appreciated language for web development.
- MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
- MySQL is customizable. The open source GPL license allows programmers to modify the MySQL software to fit their own specific environments.
How does MySQL work?
MySQL is a database server program and as such is installed on one machine, but can ‘serve’ the database to a variety of locations. To explain look at the following diagram.
The MySQL Server is installed on a Server and can be accessed directly via various client interfaces, which send SQL statements to the server and then display the results to a user. Some of these are:
- A Local Client – a program on the same machine as the server. An example of this is the command line MySQL client software we will be using in the rest of the MySQL workshops (although there are other programs including graphical interfaces).
- A Scripting Language – can pass SQL queries to the server and display the result.
- A Remote Client – a programme on a different machine that can connect to the server and run SQL statements.
You can also use two more indirect methods.
- Remote Login – You may be able to connect to the Server Machine to run one of its local clients.
- Web Browser – you can use a web browser and scripts that someone has written (we’re going to use this method for the rest of the workshop).
Download MySQL Database
If you don’t have a PHP server with a MySQL Database, you can download MySQL for free here:http://www.mysql.com/downloads/index.html
Facts About MySQL Database
One great thing about MySQL is that it can be scaled down to support embedded database applications. Perhaps it is because of this reputation that many people believe that MySQL can only handle small to medium-sized systems.
The truth is that MySQL is the de-facto standard database for web sites that support huge volumes of both data and end users (like Friendster, Yahoo, Google).
Look at http://www.mysql.com/customers/ for an overview of companies using MySQL.
Differences between SQL and MySQL
SQL stands for Structured QueryLanguage. It’s a standard language for accessing and manipulating databases.
MySQL is a database management system, like SQL Server 2005, Oracle, Informix, Postgres etc. MySQL is a RDMS (Relational Database Management System). All types of RDMB use SQL.
SQL is used to manipulate database or to create a database. It’s actually a common language. MySQL is an actual computer application. You must need to download or collect it and install it. MySQL is one of the most popular open source database management system. MySQL has an SQL interpreter.