Tutorial Gateway

MySQL Tutorial

This MySQL Tutorial explains everything about MySQL Server which includes Database creation, modification, and delete database and tables. DML, DDL statements, Built-in functions etc.

  1. How to Download MySQL
  2. Install MySQL on Windows
  3. Create Database
  4. Drop Database
  5. Create Table
  6. Select Statement
  7. Where Clause
  8. Alias Names
  9. Group By Clause
  10. Having Clause
  11. Order By Clause
  12. Limit
  13. Insert Statement
  14. Select Distinct Statement

Operators

  1. Arithmetic Operators
  2. AND
  3. NOT
  4. OR
  5. XOR
  6. Between
  7. Not Between
  8. GREATEST
  9. LEAST
  10. Coalesce
  11. IN
  12. IS NULL
  13. IS NOT NULL

MySQL Joins

  1. Inner Join
  2. Left Join
  3. Right Join
  4. Cross Join

Aggregate Functions

This MySQL tutorial section covers the list of available aggregate functions with practical examples

MySQL Date Functions

This section of MySQL tutorial covers the list of Date functions with an example of each. Refer to Date Functions introduction to understand everything about these functions.

MySQL tutorial on String Functions

This section of tutorial covers the list of String functions that are available. For each one them, we provided multiple examples. Please refer String functions article to get the introduction, and definitions of each and every function.

MySQL tutorial on Numeric Functions

This section of MySQL tutorial explains you the list of Mathematical and Trigonometric functions.

Thank You for Visiting Our Blog