MySQL – Page 45

MySQL GREATEST() Function – Find the Largest Argument in a List of Arguments

November 19, 2019July 16, 2018 by Ian

The MySQL GREATEST() function is a comparison function that returns the largest value from a list of values.

The list of values is provided as multiple arguments. So in other words, GREATEST() returns the maximum-valued argument from a list of arguments.

MIN() – Find the Minimum Value in a Column in MySQL

July 21, 2023July 16, 2018 by Ian

The MySQL MIN() function is an aggregate function that returns the minimum value from an expression.

Typically, the expression would be a range of values returned as separate rows in a column, and you can use this function to find the minimum value from the returned rows. If there are no matching rows, MIN() returns NULL.

For example, you can use this function to find out which city has the smallest population out of a list of cities.

MAX() – Find the Maximum Value in a Column in MySQL

July 21, 2023July 16, 2018 by Ian

The MySQL MAX() function is an aggregate function that returns the maximum value from an expression.

Typically, the expression would be a range of values returned as separate rows in a column, and you can use this function to find the maximum value from the returned rows. If there are no matching rows, MAX() returns NULL.

For example, you can use this function to find out which city has the largest population out of a list of cities.

ORD() Examples – MySQL

November 19, 2019July 7, 2018 by Ian

In MySQL, the ORD() function returns the numeric value of the leftmost character of a given string. You provide the string as an argument.

If the leftmost character is a multibyte character, the returned value is calculated from the numeric values of its constituent bytes. If the leftmost character is not a multibyte character, the return value is its ASCII code (which is the same result as when using the ASCII() function).

ASCII() Examples – MySQL

November 19, 2019July 7, 2018 by Ian

In MySQL, the ASCII() function returns the numeric ASCII code of the leftmost character of a given string. You provide the string as an argument.

This article contains examples of usage.

YEARWEEK() Examples – MySQL

January 28, 2021July 6, 2018 by Ian

In MySQL, the YEARWEEK() function returns the year and week for a given date. You provide the date as an argument, and the function will return the result accordingly.

You also have the option of specifying whether to start the week on Sunday or Monday, and whether the week should be in the range 0 to 53 or 1 to 53.

WEEKOFYEAR() Examples – MySQL

January 28, 2021July 6, 2018 by Ian

In MySQL, you can use the WEEKOFYEAR() function to return the calendar week for a given date. Simply provide the date as an argument and the function will return the calendar week as a number in the range from 1 to 53.

WEEKDAY() Examples – MySQL

January 28, 2021July 6, 2018 by Ian

In MySQL, you can use the WEEKDAY() function to return the weekday index for a given date. Simply provide the date as an argument and the function will return the weekday index.

WEEK() Examples – MySQL

January 28, 2021July 6, 2018 by Ian

In MySQL, you can use the WEEK() function to get the week number for a given date. By “week number” I mean the week of the year.

To use the function, simply provide the date as an argument and the week number will be returned.

You also have the option of specifying whether to start the week on Sunday or Monday, and whether the week should be in the range 0 to 53 or 1 to 53.

UTC_TIMESTAMP() Examples – MySQL

January 28, 2021July 5, 2018 by Ian

In MySQL, you can use the UTC_TIMESTAMP function to return the UTC date and time. UTC stands for Coordinated Universal Time and it’s the primary time standard by which the world regulates clocks and time.

The result of this function is returned either in ‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS format, depending on whether it’s used in a string or numeric context.