MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
Datatypes and Data Literals
Provides tutorial notes on datatypes. Topics include introduction of 5 datatypes supported in SQL-92 and MySQL; binary representations of each datatype; data literals; literal evaluations.
Character String Literal Evaluation Examples
Takeaways:
All notes and examples in chapter are tested with MySQL 8.0, 5.7, 5.6, 5.0 and 4.0 servers.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
Installing MySQL Server on Linux