Skip to main content

MySql Introduction

MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System.

MySQL Installing packages
The MySQL Installing packages comes in three flavors, you can choose any of the Installer package as per your requirements and your expertise level. These packages are:
  1. The Essential package
    The  Essential package has a Similar filename to MySQL-essential-5.0.25-win32.msi and it contains the minimum set of files needed for installation MySQL on Windows, including the Configuration Wizard except embedded server and benchmark suite. 
 "This package is recommended most of the users as the user can  install multiple instances of MySQL on a single server host and the advanced user can complete control over server configuration."
  
  1. The Complete package
    The complete package has all the needed files that are required for windows installation including configuration wizard, embedded server and bench mark suite. This package has a similar filename to  MySQL 5 . 0 . 25- win32 zip . For using it, your system must have a tool that can unpack .zip files.
     
  2. The Noinstall Archive
    The Noinstall archive package has a similar filename to mysql-noinstall-5.0 .25 -win32 . zip. This package contain all the needed set of  files  for a complete installation wizard excluding all the configuring wizard. This package has a facility of  installing manually not automatically. For using this package, there must be a tool for unpacking .zip files in your system. 
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
                    i.        MySQL are very fast and much reliable for any type of application.
                   ii.        MySQL is very Lightweight application.
                  iii.        MySQL command line tool is very powerful and can be used to run SQL           queries against database. 
                  iv.        MySQL Supports indexing and binary objects.
                   v.        It is allow changes to structure of  table while server is running.
                  vi.        MySQL has a wide user base.
                 vii.        It is a very fast thread-based memory allocation system. 
                viii.        MySQL Written in C and C++ language. 
                  ix.        MySQL code is tested with different compilers.
                   x.        MySQL is available as a separate program for use in a client/server network environment.
                  xi.        The MySQL available for the most Unix operating platform.
                 xii.        MySQL are the available for window operating system window NT, window 95 ,and window 98.
               xiii.        MySQL available for OS/2.
                xiv.        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.

Comments

Post a Comment

Popular posts from this blog

Step-by-Step guide for Installing MySQL on Windows

Step-by-Step guide for Installing MySQL on Windows Y ou can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 5.1.35 at the time of writing. Installation of MySQL Server: Unzip the setup file and execute the downloaded . MSI file. Follow the instructions below exactly when installing MySQL Server: Click on the "setup" MySQL Installing Type There are three type of MySQL Installation:- Typical  This MySQL installing process install the  MySQL server,command- line client and command line utilities. This command line and command client included in mysqldump, myisamchk and several tools to manage the MySQL Server. Complete By this installation type we install all the component included in the installation package. And this package include the component such as suppor...
Post a Comment
Read more

How to Grant Privilages to an account in MYSQL

MYSQL 'GRANT' statement allows you to grant access privileges to database account. To achieve same ,syntax  is as follow: Syntax:- GRANT privileges [Column_List] ON  [Object_Type] Privilege_level To account [IDENTIFIED BY 'password'] [ REQUIRE encryption ] WITH with_option ; Detailed explanation: Privileges:- It indicates that you have assign privileges to account. column_List : - (1) Its  optional.                          (2) Column(s) to which privileges apply. Privileges_level :- Level at which privileges apply. You can use global  privileges,database privileges,table specific privileges, column privileges etc. Account :- Which  account is being granted privileges. Password: - Specifies password.It replace old password. Required:- Clause specify whether the account has to connect to database server over secure connec...
Post a Comment
Read more

Exception Handling (RunTime Error)

Java Error Handling: In general, errors can be broken up into two categories: Design-time errors and Logical errors. Design-time errors are easy to spot because NetBeans usually underlines them. If the error will prevent the programme from running,   NetBeans will underline it in red. Logical errors are the ones that you make as a programmer. The programme will run but, because you did something wrong with the coding, there's a good chance the entire thing will crash. You'll see examples of run-time errors shortly. You'll also see how to handle them. But first a word on how Java handles errors. Exceptions What is an exception? An Exception can be anything which interrupts the normal flow of the program. When an exception occurs program processing gets terminated and doesn’t continue further. In such cases we get a system generated error message. The good thing about exceptions is that they can be handled. When an exception can occur? Exception can occur at run...
Post a Comment
Read more