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