MySQL Functions

• MySQL Substring

  MySQL substring function is a string function that allows you to extract a substring from a string start at specific position with a given length

• SQL Concatenate Functions in MySQL

  In this tutorial you will learn various ways to concatenate two or more strings together by using CONCAT function which is provided by MySQL.

• MySQL Replace Function

  MySQL provides you a useful string function called REPLACE to allow you to replace a string in a column of a table by a new string.

• Aggregate Functions in MySQL

  

  Aggregate functions allow us to perform a calculation on a set of records and return a single value. In this tutorial, you will learn various MySQL aggregate functions including SUM, AVG, MAX, MIN and COUNT functions.

• MySQL IF Function

  In this tutorial, you will learn how to use MySQL IF control flow function in your SQL statement.

• MySQL LAST_INSERT_ID

  In this tutorial, you will learn how to use MySQL LAST_INSERT_ID function to obtain last inserted ID of a record that contain an AUTO_INCREMENT column.

• MySQL DATEDIFF Function

  In this tutorial, you will learn how to use MySQL DATEDIFF function to calculate number of days between two dates or datetimes

• « Previous page
• Next page »