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.
- How to Download MySQL
- Install MySQL on Windows
- Create Database
- Drop Database
- Create Table
- Drop Table
- Select Statement
- Where Clause
- Alias Names
- Group By Clause
- Having Clause
- Order By Clause
- Limit
- Insert Statement
- Delete Command
- Select Distinct Statement
- Truncate Table
Operators
- Arithmetic Operators
- AND
- NOT
- OR
- XOR
- Between
- Not Between
- GREATEST
- LEAST
- LIKE
- NOT LIKE
- Coalesce
- IFNULL
- NULLIF
- Interval
- IN
- IS
- NOT IN
- IS NULL
- IS NOT NULL
Learn MySQL Joins
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
Use this section to learn mysql 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.