MySQL Reference


    Basics

  1. Introduction

    Commands

  2. User Management
  3. User Privileges
  4. Selectable Items

    Operations

  5. Update

    Appendices

  6. Credits

SQL Selectable Items

  • VERSON()
  • CURRENT_DATE
  • USER()
  • SHOW DATABASES; - Show the databases that exist on the server.
  • SHOW TABLES;
  • USE dbname - Use a specific database.
  • LOAD DATA;
  • DESCRIBE - Get information about a table's columns.

Keywords

  • DISTINCT
  • ORDER BY - Set the order the output is displayed in.
  • COUNT - Count rows in a table.

Comparison Operators

  • IS NULL
  • IS NOT NULL
  • LIKE m% - Items beginning with the letter m.
  • NOT LIKE
  • REGEXP