What is MySQL

MySQL is a open source Relational Database Management System. MySQL is
very fast reliable and flexible Database Management System. It provides a very high
performance and it is multi threaded and multi user Relational Database management system.
MySQL is one of the most popular relational database Management
System on the web. The MySQL
Database has become the world's most popular open source Database, because
it is free and available on almost all the platforms. The MySQL can run on Unix , window, and Mac OS.
MySQL is used for the internet applications as it provides good speed and is
very secure. MySQL was developed to manage
large volumes of data at very high speed to overcome the problems of existing
solutions. MySQL can be used for verity of applications but it is mostly
used for the web applications on the internet.
MySQL Features
- MySQL are very fast and much reliable for any type
of application.
- MySQL 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.
MySQL Advantages:
Reliability and Performance
MySQL is very reliable and high performance relational database management
system. It can used to store many GB's of data into database.
Availability of Source
MySQL source code is available that's why now you can recompile the source code.
Cross-Platform support
MySQL supports more then twenty different platform including
the major Linux distribution .Mac OS X ,Unix and Microsoft windows.
Large pool of Trained and Certified
Developers
MySQL is very popular and it is world most popular open source Database. So it is
easy
to find high quality staff around the world.
Powerful Uncomplicated software
The MySQL has most capabilities to handle most corporate database
application and used to very easy and fast
MySQL 5 Features
There are three feature of MySQL 5.0 version:-
- Views
Views is a virtual table which acts as a table but it contains no data. Views are
created using columns from one or more tables.
- Stored Procedures and Functions
MySQL 5.0 now support Stored Procedures and Functions. This allows you to embed
business logic at database level.
- Triggers
The Triggers is another very imported feature available with MySQL 5.0. Now
can add some business logic whenever data is inserted, Deleted or updated in
the table.

|
Current Comments
2 comments so far (post your own) View All Comments Latest 10 Comments:tutorials r concise n vry gud..
Posted by Sourabh Goel on Wednesday, 10.3.07 @ 11:52am | #31289
this very nice..........
Posted by Shailendra on Monday, 07.9.07 @ 10:52am | #20948