Home

MySQL tutorial

  1. Introduction
    1. About this tutorial
    2. MySQL database
    3. Definitions
    4. Tables used
    5. Sources
  2. Installation
    1. Installation from sources
    2. Changing the root password
    3. Other settings
  3. First steps
    1. Starting/stopping the server
    2. Connecting to the server
    3. Creating a database
    4. Creating a user
  4. Quick MySQL tutorial
    1. The world database
    2. Examining the database
    3. Queries
  5. Storage engines
    1. List of storage engines
    2. Choosing the right engine
    3. Specifying and altering storage engines
  6. Data types
    1. Numbers
    2. Date & time
    3. Strings
  7. Creating, altering and dropping tables
    1. CREATE and DROP statements
    2. ALTER TABLE statement
  8. MySQL expressions
    1. Literal values
    2. Variables
    3. Operators
    4. Precedence and associativity
    5. Associativity
  9. Inserting, updating and deleting data
    1. Inserting data
    2. Deleting data
    3. Updating data
  10. The SELECT statement
    1. Retrieving data
    2. Limiting data output
    3. Ordering data
    4. Selecting specific rows with the WHERE clause
    5. Removing duplicate items
    6. Grouping data
  11. Subqueries
  12. Constraints
  13. Exporting and importing data
    1. Simple data export
    2. Exporting to xml files
    3. Using mysqldump tool
  14. Joining tables
    1. Inner joins
    2. Outer joins
    3. Natural joins
    4. Quick recap
  15. MySQL functions
    1. Mathematical functions
    2. Aggregate functions
    3. String functions
    4. Date & time functions
    5. System functions
  16. Views
    1. View definition
    2. Creating, modifying and dropping a view
    3. Finding views
    4. Creating a view with a union
  17. Transactions
    1. Definition of transaction
    2. Isolation levels
    3. Autocommit
    4. Starting transactions
  18. Stored routines
    1. A simple procedure
    2. A simple function
    3. Procedure parameters
    4. Random numbers
    5. Finding routines

This is MySQL tutorial. It covers the MySQL database engine and the SQL language supported by the database engine.

Similar tutorials
SQLite tutorial
MySQL C API tutorial
MySQL PHP tutorial
MySQL Visual Basic tutorial
MySQL Python tutorial
MySQL Java tutorial
MySQL Perl tutorial