Introduction to MySQL

MySQL is a database, it is a data storage area where small sections called TABLES. These tables having number of rows and columns. A database is a data storage feature where user can perform many action like: insert, update, delete, select, sort, arrange, and display information.

MySQL is a open source RDBMS (Relational Database Management System). It is very popular relational database Management System because it is free available for all platform. It is very much reliable and flexible. It provides a very high performance and it is multi threaded and multi user Relational Database management system.

The MySQL support almost all operating system like: Unix , window, and Mac. MySQL is used for the internet applications because it has high speed and highly secure. MySQL was developed to manage large volumes of data at very high speed for the web application.

Features of MySQL

* MySQL Handles large databases.
* MySQL has no memory leaks.
* The MySQL Passwords are secure since all password traffic when connecting to a server is encrypted.
* MySQL is very fast and more reliable for any type of application.
* It is very Lightweight application.
* MySQL command line tool is very powerful and can be used to run SQL queries against database.
* MySQL Supports indexing and binary objects.
* It is allow changes to structure of table while server is running.
* MySQL has a wide user base.
* It is a very fast thread-based memory allocation system.
*

MySQL Written in C and C++ language.
*

MySQL code is tested with different compilers.
*

MySQL is available as a separate program for use in a client/server network environment.
*

The MySQL available for the most Unix operating platform.
* MySQL are the available for window operating system window NT, window 95 ,and window 98.
* MySQL available for OS/2.
* Programming libraries for C, Python, PHP, Java , Delphi etc. are available to connect to MySQL database.

Advantages of MySQL

* Reliability and Performance
* Availability of Source
* Cross-Platform support
* Powerful Uncomplicated software

Features of MySQL 5

* Views: Views is created using columns from one or more tables. It is a virtual table which acts as a table but it contains no data. .
* Stored Procedures and Functions: In this feature it allows to user to plant business logic at database level.
* Triggers: The Triggers is used to create business logic whenever data is inserted, Deleted or updated in the table.

For more about MySQL: http://www.mysql.com/