Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Spring Framework | Web Services | BioInformatics | Java Server Faces | Jboss 3.0 tutorial | Hibernate 3.0 | XML

Tutorial Categories: Ajax | Articles | JSP | Bioinformatics | Database | Free Books | Hibernate | J2EE | J2ME | Java | JavaScript | JDBC | JMS | Linux | MS Technology | PHP | RMI | Web-Services | Servlets | Struts | UML

[an error occurred while processing this directive]

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

  1. MySQL are very fast and much reliable for any type of application.
  2. MySQL is very Lightweight application.
  3. MySQL command line tool is very powerful and can be used to run SQL queries against database. 
  4. MySQL Supports indexing and binary objects.
  5. It is allow changes to structure of  table while server is running.
  6. MySQL has a wide user base.
  7. It is a very fast thread-based memory allocation system. 
  8. MySQL Written in C and C++ language. 

  9. MySQL code is tested with different compilers.

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

  11. The MySQL available for the most Unix operating platform.

  12. MySQL are the available for window operating system window NT, window 95 ,and window 98.
  13. MySQL available for OS/2.
  14. 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.

                         

Facing Programming Problem?
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 

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

      View This Comment Separately

this very nice..........

Posted by Shailendra on Monday, 07.9.07 @ 10:52am | #20948

      View This Comment Separately

Leave your comment:

Name:

Email:

URL:

Title:

Comments:


Enter Code:

 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Tell A Friend
Your Friend Name
Search Tutorials

 

 
 
Browse all Java Tutorials
Java JSP Struts Servlets Hibernate XML
Ajax JDBC EJB MySQL JavaScript JSF
Maven2 Tutorial JEE5 Tutorial Java Threading Tutorial Photoshop Tutorials Linux Technology
Technology Revolutions Eclipse Spring Tutorial Bioinformatics Tutorials Tools SQL
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2007. All rights reserved.