What is MySQL?
MySQL is an Open Source database management system(DBMS) that one can download for free from MySQL Website (www.mysql.com). MySQL is one of the world’s most popular systems for Java web applications because of its consistent fast performance, high reliability and ease of use. MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving the developers right kind of flexibility.
MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase. The project’s source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements.
Why is MySQL more popular among Web Developers?
1. Inexpensive: MySQL is free for most of the uses and relatively inexpensive for other enteroprise support
2. Fast: MySQL is one of the fastest relational databases currently available.
3. Easy To Use: MySQL is easy to use and install when compared to other DBMS
4. Portable: MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving the developers right kind of flexibility.
5. Supports Strutured Query Language(SQL) and provides most of the features that one would expect from a modern RDBMS.
What does MySQL Provide?
1. SQL Support: MySQL supports SQL which is the standard language for working with relational databases.
2. Multiple Client Support: MySQL supports access from multiple clients and also supports multiple programming langauges including PHP, Java, Perl, Python, and C.
3. Connectivity: MySQL can provide access to data via Internet or intranet
4. Security: MySQL provide security so that only authorised users can view the data.
5. Referential Integrity: MySQL provides support for referential integrity just like commercial databases such as Oracle Database or Microsoft SQL Server.
6. Transaction Processing: MySQL 5.0 provides support for transaction processing just like other commercial databases