MySQL Tutorials - Herong's Tutorial Examples
∟Commonly Used Functions
This chapter provides tutorial notes on built-in functions. Topics include commonly used flow control functions, character string functions, numeric functions, date and time functions, the cast function.
Flow Control Functions
Character String Functions
Numeric Value Functions
Date and Time Functions
JSON Document Functions
XML Document Functions
Spatial Data Functions
Cast Function
Takeaways:
- Flow control functions return different values based on different conditions like CASE and IF
functions.
- Character string functions work on character string values like CONCAT(), CHAR_LENGTH(),
SUBSTRING(), and TRIM() functions.
- Numeric functions work on numeric values like ABS(), COS(), RANDOM(), and ROUND() functions.
- Date and time functions work on date and time values like CURRENT_DATE(), CURRENT_TIME() and
EXTRACT() functions.
- JSON document functions work on JSON documents like, JSON_VALID(), JSON_TYPE(), JSON_ARRAY(),
JSON_OBJECT(), JSON_EXTRACT(), JSON_REMOVE(), JSON_REPLACE(), JSON_SET(), and JSON_INSERT() functions.
- XML document functions work on XML documents like, ExtractValue() and UpdateXML() functions.
- Spatial functions work on geometric spatial objects like, ST_GeomFromText(), ST_AsText(),
ST_GeometryType(), POINT(), ST_X(), ST_Y(), ST_NumPoints(), ST_PointN(), ST_Area(), etc. functions.
- The CAST() function can convert a value of any datatype to any other datatype.
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
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Locks Used in MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
MySQL Server Administration
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Bulk Changes on Large Tables
MySQL Server on macOS
Installing MySQL Server on Linux
Connection, Performance and Second Instance on Linux
Archived Tutorials
References
Full Version in PDF/EPUB