Tutorials

Tutorials

MySQL - Index

  1. MySQL Introduction
  2. MySQL Table Types/Storage Engines
  3. Sample Databases used in this MySQL tutorial
  4. Data Definition Language (DDL)
    1. CREATE DATABASE Syntax
    2. DROP DATABASE Syntax
    3. ALTER DATABASE Syntax
    4. CREATE TABLE Syntax
    5. ALTER TABLE Syntax
    6. DROP TABLE Syntax
    7. TRUNCATE TABLE Syntax
    8. RENAME TABLE Syntax
    9. CREATE INDEX Syntax
    10. DROP INDEX Syntax
  5. Data Manipulation Language (DML)
    1. Inserting Data into MySQL Table
    2. Update Data in Columns
    3. Deleting Data from Database Tables
    4. Querying Data using MySQL Select Statement
    5. MySQL BETWEEN AND Operator
    6. MySQL LIKE Operator
    7. MySQL UNION Syntax
    8. Joins in MySQL
    9. Subqueries
  6. MySQL Functions
    1. Aggregate Functions
    2. Information Functions
    3. Date and Time Functions
    4. String Functions
Content: Tutorials