Search results
Learn how to use built-in functions in MySQL for string, numeric, date, and some advanced operations. See the function name, description, syntax, and examples for each function.
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, “Using Stored Routines”.
Introduction to MySQL Stored Function. A stored function is a specialized type of stored program designed to return a single value. Typically, you use stored functions to encapsulate common formulas or business rules, making them reusable across SQL statements or other stored programs.
Base-64 encoded strings can be decoded using the FROM_BASE64() function. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')); -> 'JWJj', 'abc' Different base-64 encoding schemes exist. These are the encoding and decoding rules used by TO_BASE64() and FROM_BASE64():
This chapter describes the SQL functions and operators that are permitted for writing expressions in MySQL. Instructions for writing stored functions and user-defined functions are given in Section 24.2, “Using Stored Routines”, and Adding Functions to MySQL.
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, “Using Stored Routines”.
This page explores the most frequently used MySQL mathematical functions with practical & real world examples. This section gives you the most commonly used MySQL functions including aggregate functions, string functions, date functions, and control flow functions.
