My Sql – Introduction

My Sql – Introduction

MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS) with more than six million installations. MySQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. MySQL is frequently used by PHP and Perl scripts. The SQL commands discussed in this tutorial apply to MySQL operating under all operating systems.

What is MySQL?
MySQL is a database. There are many types of databases and most use SQL (Structured Query Language) to communicate with it. It uses words like "CREATE TABLE" or "INSERT INTO" to run queries on the database. In MySQL the syntax can look a little bit different than other database styles. Oracle does not allow the ` character. MySQL likes it when you put those around table names and column names.

Databases contain Tables which contain rows. Databases could be compared to folders which contain files called tables. In the tables there are rows, which is where the data is stored. Every table has columns defined when it is created. These columns specify what type of data will be stored. Every row in the table follows the column’s guidelines. Databases can hold more than one table and a table can hold more than one row.

Connecting to and Disconnecting from the Server

To connect to the server, i they need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where it is log in, also need to specify a hostname.

shell> mysql -h host -u user -p

Enter password: ********

The ******** represents your password; enter it when mysql displays the Enter password: prompt. If that works, you should see some introductory information followed by a mysql> prompt:

shell> mysql -h host -u user -p

Enter password: ********

Welcome to the MySQL monitor. Commands end with ; or \g.

mysql>

The prompt tells you that mysql is ready for you to enter commands.After you have connected successfully, you can disconnect any time by typing QUIT at the mysql> prompt:

mysql> QUIT

Bye

You can also disconnect by pressing Control-D.

 

Features of MySQL

  1. Speed :
    Ofcourse, the speed at which a server side program runs depends primarily on the server hardware. Given that the server hardware is optimal, MySQL runs very fast. It supports clustered servers for demanding applications.
  2. Ease of use :
    MySQL is a high-performance, relatively simple database system. From the beginning, MySQL has typically been configured, monitored, and managed from the command line. However, several MySQL graphical interfaces are available as described below:
    1. MySQL Administrator: This tool makes it possible for administrators to set up, evaluate, and tune their MySQL database server. This is intended as a replacement for mysqladmin.
    2. MySQL Query Browser: Provides database developers and operators with a graphical database operation interface. It is especially useful for seeing multiple query plans and result sets in a single user interface.
    3. Configuration Wizard: Administrators can choose from a predefined list of optimal settings, or create their own.
      MySQL System Tray: Provides Windows-based administrators a single view of their MySQL instance, including the ability to start and stop their database servers.
  3. Cost :
    MySQL is available free of cost. MySQL is a "Open Source" database. MySQL is part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python) environemtn, a fast growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost, reliability, and documentation.
  4. Query Language Support :
    MySQL understands standards based SQL (Structured Query Language).
  5. Capability :
    Many clients can connect to the server at the same time. Clients can use multiple database simultaneously. You can access MySQL using several interfaces such as command-line clients, Web browsers.
  6. Connectivity and security :
    MySQL is fully networked, and database can be accessed from anywhere on the Internet, so you can share your data with anyone, anywhere. The connectivity could be achieved with Windows programs by using ODBC drivers. By using the ODBC connector to MySQL, any ODBC-aware client application (for example, Microsoft Office, report writers, Visual Basic) can connect to MySQL.
  7. Portability :
    MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: