Operations and Expressions

MySQL Tutorials - Herong's Tutorial Examples

∟Operations and Expressions

Provides tutorial notes on operations and expressions. Topics include types of operations and expressions; arithmetic operations; predicate operations; data and time operations; examples of different types of operations.

What Is Expression

Arithmetic Operations

Predicate Operations

Date and Time Operations

Examples of Different Types of Operation

Takeaways:

Types of expressions: numeric expression, character string expression, bit string expression, data and time expression.
Types of operations: arithmetic operation, predicate operation, data and time operation.

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

About This Book

Introduction of SQL

MySQL Introduction and Installation

Introduction of MySQL Programs

PHP Programs and MySQL Server

Perl Programs and MySQL Servers

Java Programs and MySQL Servers

Datatypes and Data Literals

►Operations and Expressions

Character Strings and Bit Strings

Commonly Used Functions

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

Locks Used in MySQL

Defining and Calling Stored Procedures

Variables, Loops and Cursors Used in Stored Procedures

Using Administration Statements

MySQL Server on macOS

Installing MySQL Server on Linux

Connection, Performance and Second Instance on Linux

Outdated Tutorials

Full Version in PDF/EPUB