MySQL Basics

This section describes the basic operations of data manipulation in MySQL, including inserting data, deleting data, modifying data and querying data.

  1. MySQL SELECT

    This article describes basic syntax of the SELECT statement, and how to use the SELECT statement to query data from the database.

  2. MySQL WHERE

    This article describes how to use the WHERE clause to filter data in a MySQL database.

  3. MySQL AND

    This article describes how to use the AND operator in the WHERE clause to combine multiple query conditions.

  4. MySQL OR

    This article describes how to use the OR operator in the WHERE clause to combine multiple query conditions.

  5. MySQL IN

    In this article, we describes how to use MySQL IN operator to test whether a value is included in a list.

  6. MySQL BETWEEN

    In this article, you will learn MySQL BETWEEN operator and its use cases.

  7. MySQL LIKE

    In this article, you will learn MySQL LIKE operator and its use cases.

  8. MySQL IS NULL

    This article describes the syntax and usage of MySQL IS NULL operator.

  9. MySQL EXISTS

    In this article, we will explore how to use MySQL EXISTS operator.

  10. MySQL ORDER BY

    In this article, we describe how to use MySQL ORDER BY clause to sort the result set of the SELECT statement.

  11. MySQL LIMIT

    This article describes how to limit the number of rows of result set using the MySQL LIMIT clause.

  12. MySQL DISTINCT

    This article describes how to remove duplicate rows in the result using MySQL DISTINCT keyword.

  13. MySQL JOIN

    In this article, we will introduce MySQL inner joins, left joins, right joins, and cross joins.

  14. MySQL GROUP BY

    This article will describes MySQL GROUP BY clause which can group some rows by specified columns or expression.

  15. MySQL UNION

    In this article, we will discuss the syntax and useage of MySQL UNION operator.

  16. MySQL ALIAS

    In this article, we discussed column aliases, table aliases and derived table aliases in MySQL, and the use of aliases to simplify SQL and improve the readability of SQL.

  17. MySQL subqueries

    This article describes what MySQL subqueries are and how to write SQL statements using subqueries.

  18. MySQL INSERT

    In this article, we will use MySQL INSERT statement to insert one or more rows into a table.

  19. MySQL DELETE

    This article describes how to remove rows from a table by MySQL DELETE statement.

  20. MySQL UPDATE

    This article describes how to use MySQL UPDATE statement to update one or more rows.

  21. MySQL REPLACE

    In this article, you will learn about MySQL REPLACE statement and how to use it to insert rows into a table.