Friday, August 20, 2010

Mysql concepts made easy

MySQL INTRODUCTION
Mysql made easy to understand and with simple examples

What is Mysql????

MySQL, pronounced "my Ess Que El," is an open source, Enterprise-level, multi-threaded, relational database management system.

MySQL was developed by a consulting firm in Sweden called TcX. They were in need of a database system that was extremely fast and flexible. Unfortunately (or fortunately, depending on your point of view), they could not find anything on the market that could do what they wanted. So, they created MySql, which is loosely based on another database management system called MySql.

The product they created is fast, reliable, and extremely flexible. It is used in
many places throughout the world. Universities, Internet service providers and nonprofit organizations are the main users of MySQL, mainly because of its price (it is mostly free).

Lately, however, it has begun to permeate the business world as a reliable and fast database system. The reason for the growth of MySQL's popularity is the advent of the Open Source Movement in the computer industry.

The Open Source Movement, in case you haven't heard about it, is the result of several computer software vendors providing not only a product but the source code aswell.

Now lets us know what is Database????




A database is a series of structured files on a computer that are organized in a highly efficient manner.

These files can store tons of information that can be manipulated and called on when needed.

A database is organized in the following hierarchical manner, from the top down. You start with a database that contains a number of tables. Each table is made up of a series of columns. Data is stored in rows, and the place where each row intersects a column is known as a field.

let us know what are the Features of MySql:

Features of MySQL
Relational database management system
  • Multithreaded server
  • Adheres to the standard set by the American national standards institute for sql
  • Online help system
  • Has Many APIs
  • Portability
So guys i shall discuss about download and Working with mysql Basic commands in my next post.


No comments:

Post a Comment