14 Sep MySQL Examples

MySQL is one of the most popular RDBMS, wherein records are stored in tables. It was released in the year 1995. We have made a list of live-running MySQL query examples topic-wise.

Let’s begin:

MySQL CREATE

• CREATE DATABASE Statement
• CREATE TABLE Statement

MySQL STATEMENTS

• SELECT Statement
• SELECT DISTINCT Statement
• UPDATE Statement
• DELETE Statement
• CASE Statement

MySQL ORDER BY

• ORDER BY Statement

MySQL Constraints

• MySQL PRIMARY KEY Constraint
• MySQL UNIQUE Constraint
• MySQL DEFAULT Constraint
• MySQL CHECK Constraint
• MySQL INDEX Constraint
• MySQL NOT NULL Constraint

MySQL Operators

• MySQL AND Operator
• MySQL OR Operator
• MySQL NOT Operator
• MySQL LIKE Operator
• MySQL IN Operator
• MySQL BETWEEN and NOT BETWEEN Operator

MySQL Built-in Functions

• MySQL AVG() Method
• MySQL SUM() Method
• MySQL MIN() Method
• MySQL MAX() Method
• MySQL COUNT() Method

MySQL Clauses

• MySQL LIMIT Clause
• MySQL WHERE Clause

MySQL DROP Statement

• DROP DATABASE Statement
• DROP TABLE Statement

MySQL ALTER TABLE Statement

• Add a column in a MySQL table
• Drop a column in a MySQL table
• Modify a column in a MySQL table