MySQL Database - Introduction
  • Introduction to database
  • Using The Files(1)
MySQL Database - Practice
  • MySQL Installation Information
  • MySQL - Setup a Package Manager
  • MySQL - Setup Working Environment
  • Changing Time Zone for MySQL
  • MySQL - Select, Keyword, Expressions and Functions
  • MySQL Row Selection
  • MySQL Column Selection
  • ORDER BY ASC and DESC
  • WHERE Clause
  • LIKE and IN Clauses
  • REGEXP and RLIKE
  • Using INSERT INTO to Insert Data
  • Using UPDATE SET to Update Data
  • DELETE and DROP
  • MySQL Strings
  • What is NULL
  • CREATE and USE DATABASE
  • Using Tables
  • Using Indexes
  • Using Constraints
  • AUTO_INCREMENT, PRIMARY KEY and SERIAL
  • ALTER TABLE
  • MySQL Data Type Introduction
  • Numeric Types
  • MySQL String Types
  • MySQL DATE and TIME Types
  • BIT
  • BOOLEAN Types
  • ENUM and SET
  • MySQL String Function
  • MySQL Numeric Functions
  • Date and Time Functions
  • MySQL Time Zone Support
  • DTAE_FORMAT Function
  • MySQL Grouping Functions
  • MySQL Conditional Function
  • MySQL - How To Use Transactions
  • Transactions and Performance
  • Using TRIGGER
  • Using TRIGGER Preventing Auto Update
  • Triggers and Transactions
  • How To Use Subselect and SUBSTR
  • MySQL - Searching Within a Result Set
  • How To Create VIEWs
  • How To Create JOIN VIEW
  • MySQL - Routines
  • MySQL Functions
  • MySQL Procedures
  • What is PDO
  • PDO and Prepared Statement