Introduction to MySQL

  • MySQL is an open source relational database management system.
  • There is no fee for the installation of MySQL. It is fully free for the users.
  • MySQL helps the users to use all the concepts of RDBMS (Relational Database Management System).
  • We can insert records, update records, delete records, select records, Create table, drop table, truncate table, etc. using MySQL database.

What is MySQL?

MySQL is an open source database application stored in a collection of data and used for the creation of dynamic server-side most powerful user-friendly applications.

Reasons for popularity

MySQL database is most popular due to the following reasons:

  • MySQL is an open source, so users have no need to pay any cost of the installation of MySQL database.
  • Very user-friendly, easy to access for any user.
  • MySQL handles a large set of functionality due to its nature of powerfulness.
  • MySQL is faster than other databases so it can perform better even with a large set of data.
  • We can easily customize the MySQL database as it is an open source database.
  • MySQL has open-source GPL license that facilitates programmers to modify the SQL software.
  • Allow the user to implement a database with tables, columns, and indexes.
  • MySQL is compatible with all the operating systems like a Windows, Linux, etc.
  • MySQL supports many languages like PHP, PERL, C, C++, JAVA, etc.
  • MySQL is compatible and friendly with PHP, the most popular language for web development.
  • MySQL supports huge databases, up to 50 million rows or more in a table.
  • MySQL default file size limit for a table is 4GB.
  • The facility to increase the size is up to 8 million terabytes (TB) if your operating system can handle it.
  • MySQL is very friendly with PHP hence easy established relation between frontend and backend.

MySQL Tutorial menu list

  1. MySQL Tutorial
  • What is MySQL
  • Reason of popularity
  • History of My SQL
  • MySQL Features
  • MySQL data Types
  • Install MySQL
  1. MySQL Database
  • Create Database
  • Select Database
  • Drop Dtabase
  1. Table & Views
  • CREATE Table
  • ALTER Table
  • TRUNCATE Table
  • DROP Table
  • MySQL Views
  1. MySQL Queries
  • INSERT Records
  • UPDATE Records
  • DELETE Records
  • SELECT Records
  1. MySQL Clauses
  • MySQL WHERE
  • MySQL DISTINCT
  • MySQL FROM
  • MySQL ORDER BY
  • MySQL GROUP BY
  • MySQL HAVING
  1. MySQL Conditions
  • MySQL AND
  • MySQL OR
  • MySQL AND OR
  • MySQL LIKE
  • MySQL IN
  • MySQL NOT
  • MySQL IS NULL
  • MySQL IS NOT NULL
  • MySQL BETWEEN
  1. MySQL Join
  2. Aggregate Functions
  • MySQL count()
  • MySQL sum()
  • MySQL avg()
  • MySQL min()
  • MySQL max()
  • MySQL first()
  • MySQL last()
  1. MySQL Misc
  • MySQL comments
  • MySQL Cursor
  • MySQL Function
  • MySQL Literals(Constants)
  • MySQL Date & Time
  • MySQL procedure
  • MySQL Trigger
  1. MySQL Regexp
  • Not Like Operator
  • Not regexp Operator
  • regexp Operator
  • regexp_instr() Function
  • regexp_like() Function
  • regexp_replace() Function
  • regexp_substr() Function
  1. Differences
  • MariaDB vs MySQl
  • PostgreSQL vs MySQL

Pin It on Pinterest

Share This