MYSQL INTRODUCTION

                                         MYSQL INTRODUCTION



        1.It is an database store collection of data.Datas are stored in the format of table which contains cloumns and rows.

       2. MySql is an opensource language in the programming world and also platfoem independent.

       3. It uses Apache Server because apache is a opensource and MySql is user friendly with PHP.

       4. It is designed by using C  and C ++  and developed by MYSQL AB corporation at 1995 but now it is owned by ORACLE.

      5. It is used by so many large companies like Facebook, Youtube, Google and most important is it is a structured query language.

     6. It is current version is 5.7.


We can able to do th efollowing activites by using Mysql:

            a. It is executes a table against Datebases.

           b.  It is used to crate a table in a Datebases.

           c. It is used to add a any additional records in a current table.

          d. It is used to modify a table in a Datebases

Types of Databases:

            There are two types of Databases

                       1. DBMS( Database Management System)

                       2. RDBMS( Relationship Database Management System)

DBMS:

                1. Data's are stored in the form of file.

                2. No relations between tables


RDMS:

              1. Datas are stored in the form of table

              2. It is opposite to DBMS which means it have the relationship between table.

Packages:

       In the following packages we can able to use the Mysql.

       WAMP: Windows Apache Mysql PHP

       LAMP: Linux Apache Mysql PHP
 
      MAMP: MAC Apache Mysql PHP


 Types of Commands used in Mysql:

      1. DDL(Data Definition Language):

                In this section we can able to create, alter, rename, drop, truncate the table.

     2. DML(Data Manipulation Language):

              In this section we can able to insert, update, delete the table.

     3. TCL (Translation Control Language):
   
            By using this language we can able to autocommit, savepoint, rollback.