MySQL is a very powerful program that can handle a large set of functionality of the most expensive and powerful database packages. MySQL is customizable because it is an open-source database, and the open-source GPL license facilitates programmers to modify the SQL software according to their own specific environment.
MYSQL is a widely used relational database management system (RDBMS).
- It is free and open-source.
- It is ideal for both small and large applications.
Tutorial
- Intro
- RDBMS
Basic Commands
- SELECT
- WHERE
- AND, OR, NOT
- ORDER BY
- INSERT INTO
- NULL Values
- UPDATE
- DELETE
- MIN and MAX
- COUNT, AVG, SUM
- LIKE
- Wildcards
- IN BETWEEN
- Aliases
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CROSS JOIN
- Self Join
- UNION
- GROUP BY
- HAVING
- EXISTS ANY, ALL
- INSERT SELECT
- CASE
- Null Functions
- Comments
- Operators
Database
- Create DB
- Drop DB
- Create Table
- Drop Table
- Alter Table
- Constraints
- Not Null
- Unique
- Primary Key
- Foreign Key
- Check Default
- Create Index
- Auto Increment
- Dates
- View