MySQL - Introduction

What is MYSQL Database?

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). Mysql database is used to store data.

  • MYSQL is a standard language for accessing and manipulating databases.
  • Mysql database is used to insert records in a database.
  • Mysql database is used to update records in a database.
  • Mysql database is used to select records in a database.
  • Mysql database is used to delete records in a database.
  • Mysql database is used to create database in a database.
  • Mysql database is used to create table in a database.
  • Mysql database is used to create stored procedures in a database.
  • Mysql database is used to create views in a database
  • Mysql database is used to set permissions on tables, procedures, and views

MySQL database system structure

MySQL database system has below structure.

  • Database  -  Database is collection of tables, meta data and records.
  • Tables -  Tables is collection of records.
  • Column - Column defines data element name like username, password, address, mobile, city, state etc.
  • Row - Row is is a group of related data.
  • Primary key - A primary key is unique key. A primary key can not be null.
  • Foreign Key - A Foreign Key is refrence key which is used to maintain relationship between two table.
  • Index - A Index key is used to make searching record faster in table.

Why We should use MYSQL Database?

  • MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.
  • MySQL is released under an open-source license. So it is free to use.
  • MySQL works on many operating systems and supports many languages like PHP, PERL, C, C++, JAVA, etc.
  • MySQL is very friendly to PHP which is used widely for web development.
  • MySQL works very quickly for large data up to 50 million rows or more in a table

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

33821