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
Date and Time Operations
Examples of Different Types of Operation
- 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
Full Version in PDF/EPUB