MySQL Functions

This is an alphabetical listing of our documentation of MySQL functions. This is provided as a quick way to get to the documentation page when you know which function you need information on. The more popular functions are highlighted with blue text for the heading.

ABS( )
This MySQL function returns the absolute value of a given number.
page views: 2,845;
category: Funzioni Matematiche
EXPORT_SET( )
This MySQL function returns a series of strings in order that represent each bit of a given number.
page views: 2,714;
category: Funzioni Stringa
RADIANS( )
This MySQL function converts degrees to radians.
page views: 2,638;
category: Funzioni Matematiche
ACOS( )
This MySQL function returns the arccosine, in radians, of a given number.
page views: 2,546;
category: Funzioni Matematiche
This MySQL function extracts date or time information from a date or a datetime expression in the format type requested.
page views: 3,664;
category: Funzioni Data e Ora
This MySQL function returns a random floating-point number from 0 to 1.
page views: 2,903;
category: Funzioni Matematiche
This MySQL function returns the arccosine, in radians, of a given number.
page views: 2,949;
category: Funzioni Matematiche
FIELD( )
This MySQL function searches for the first string given in the following list of strings and returns the numeric position of the first string in the list that matches.
page views: 2,746;
category: Funzioni Stringa
This MySQL function releases a lock created by GET_LOCK().
page views: 7,978;
category: Tavola e Server Istruzione Amministrazione
This MySQL function can be used to add a given interval of time to a date or the value of a date column
page views: 3,089;
category: Funzioni Data e Ora
This MySQL function returns the location of the first argument within a comma-separated list that is passed as a single stringin the second argument.
page views: 7,190;
category: Funzioni Stringa
This MySQL function returns the string given in the first argument of the function, as many times as specified in the second argument.
page views: 3,475;
category: Funzioni Stringa
Similar to ADDDATE(), but specifically and supposedly for adding time to a value. However, both MySQL functions allow the addition of date and time to a value.
page views: 4,345;
category: Funzioni Data e Ora
This MySQL function rounds a given floating-point number down to the next lower integer.
page views: 3,007;
category: Funzioni Matematiche
This MySQL function goes through the first argument and returns a string in which every occurrence of the second argument is replaced with third argument.
page views: 3,450;
category: Funzioni Stringa
Questa funzione MySQL decifra testo che è stato crittografato utilizzando l'algoritmo AES algoritmo con 128-bit di lunghezza della chiave, invertendo la <tt>AES_ENCRYPT( )</tt>.
page views: 3,640;
category: Istruzione di Utente e Sicurezza
This MySQL function returns the given floating-point number with a comma inserted between every three digits and a period before the number of decimal places specified in the second argument
page views: 3,434;
category: Funzioni Matematiche
This MySQL function returns the characters of string in reverse order.
page views: 3,043;
category: Funzioni Stringa
AES_ENCRYPT( )
Questa funzione MySQL crittografa una data stringa utilizzando l'algoritmo AES algoritmo con 128-bit di lunghezza della chiave.
page views: 2,791;
category: Istruzione di Utente e Sicurezza
Use this MySQL function in conjunction with the SQL_CALC_FOUND_ROWS option of a SELECT statement to determine the number of rows an SQL statement using a LIMIT clause wou
page views: 3,713;
category: Altri Funzioni
This MySQL function returns the final length characters from a string.
page views: 3,661;
category: Funzioni Stringa
ANALYSE( )
This MySQL function returns an analysis of a results table from a SELECT statement.
page views: 2,827;
category: Altri Funzioni
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 5,026;
category: Funzioni Data e Ora
ROUND( )
This MySQL function rounds a number given in the first argument to the nearest integer.
page views: 2,764;
category: Funzioni Matematiche
This MySQL function returns the numeric code corresponding to the first character of a given string.
page views: 3,110;
category: Funzioni Stringa
This MySQL function returns the date based on Unix time, which is the number of seconds since January 1, 1970, Greenwich Mean Time (GMT).
page views: 4,637;
category: Funzioni Data e Ora
This MySQL function returns the number of rows changed by the previous SQL statement.
page views: 3,692;
category: Altri Funzioni
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 2,609;
category: Funzioni Matematiche
This MySQL function returns the format for a given data type, based on the standard given as the second argument.
page views: 3,553;
category: Funzioni Data e Ora
This MySQL function adds padding to the right end of string, stopping if the combination of string and the added padding reach length characters.
page views: 3,581;
category: Funzioni Stringa
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 2,838;
category: Funzioni Matematiche
GET_LOCK( )
This MySQL function attempts to get a lock on the name given in the first argument.
page views: 2,847;
category: Tavola e Server Istruzione Amministrazione
RTRIM( )
This MySQL function returns the given string with any trailing spaces removed.
page views: 2,798;
category: Funzioni Stringa
ATAN( )
This MySQL function returns the arctangent, in radians, of a given number.
page views: 2,744;
category: Funzioni Matematiche
GREATEST( )
This MySQL function compares two or more values, returning the greatest value.
page views: 2,787;
category: Funzioni Matematiche
SCHEMA( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,699;
category: Altri Funzioni
This MySQL function returns the arctangent, in radians, of X and Y for a point on a Cartesian plane.
page views: 2,879;
category: Funzioni Matematiche
This MySQL function returns non-NULL values of a group concatenated by a GROUP BY clause, separated by commas.
page views: 3,695;
category: Funzioni Aggregative
This MySQL function returns the seconds value (0-59) for a given time.
page views: 3,509;
category: Funzioni Data e Ora
This MySQL function returns the average or mean of a set of numbers given as the argument.
page views: 3,229;
category: Funzioni Aggregative
The first version of this MySQL function accepts a string and returns its numerical value, in hexadecimal, as it is represented in the underlying character set.
page views: 2,975;
category: Funzioni Stringa
This MySQL function returns the period for a given number of seconds in the format hh:mm:ss.
page views: 7,790;
category: Funzioni Data e Ora
BENCHMARK( )
Use this MySQL function to evaluate the performance of a MySQL server.
page views: 2,606;
category: Altri Funzioni
HOUR( )
This MySQL function returns the hour for a DATETIME or TIME column.
page views: 2,855;
category: Funzioni Data e Ora
Questa funzione MySQL restituisce il nome utente e il nome host per la connessione corrente MySQL. La funzione non ha argomenti.
page views: 4,326;
category: Istruzione di Utente e Sicurezza
BIN( )
This MySQL function returns a binary number for a given integer.
page views: 2,738;
category: Funzioni Stringa
This MySQL function returns the result given in the second argument if the condition given in the first argument is met (i.e., the condition does not equal 0 or NULL).
page views: 3,628;
category: Controllo Flusso
Questa funzione MySQL restituisce il Secure Hash Algorithm (SHA) 160-bit di checksum per la stringa data. I risultati sono una stringa composta da 40 cifre esadecimali.
page views: 2,962;
category: Istruzione di Utente e Sicurezza
BINARY
Use this MySQL function to treat strings in their binary state.
page views: 2,748;
category: Funzioni Stringa
This MySQL function returns the results of the condition given in the first argument of the function if its results are not NULL.
page views: 2,933;
category: Controllo Flusso
SIGN( )
This MySQL function returns -1 if the given number is a negative, 0 if it is zero, and 1 if it is positive.
page views: 2,670;
category: Funzioni Matematiche
BIT_AND( )
This MySQL function returns the bitwise AND for all bits for the expression given. I'll confess here: I really have no idea what this does, although I wrote something about it.
page views: 2,838;
category: Funzioni Aggregative
This MySQL function converts an Internet Protocol (IP) address in dot-quad notation to its numeric equivalent.
page views: 3,679;
category: Funzioni Matematiche
SIN( )
This MySQL function returns the sine of the number given, where number is expressed in radians.
page views: 2,833;
category: Funzioni Matematiche
This MySQL function returns the number of bits set in the argument, which is an integer that the function treats as a binary number.
page views: 2,890;
category: Funzioni Matematiche
This MySQL function converts the numeric equivalent of an IP address to its dot-quad notation.
page views: 3,592;
category: Funzioni Matematiche
This MySQL function pauses the execution of an SQL statement in which it is given, for the number of seconds given.
page views: 11,870;
category: Funzioni Data e Ora
BIT_LENGTH( )
This MySQL function returns the number of bits in a given string.
page views: 2,754;
category: Funzioni Stringa
INSERT( )
This MySQL function inserts the string from the final argument into the string specified by the first argument, at the specified position.
page views: 2,648;
category: Funzioni Stringa
This MySQL function returns the results of a classic algorithm that can be used to compare two similar strings.
page views: 3,016;
category: Funzioni Stringa
This MySQL function returns the bitwise OR for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 3,177;
category: Funzioni Aggregative
This MySQL function returns the starting position of the first occurrence of the substring in the string given as the first argument.
page views: 3,111;
category: Funzioni Stringa
SPACE( )
This MySQL function returns a string of spaces.
page views: 2,673;
category: Funzioni Stringa
BIT_XOR( )
This MySQL function returns the bitwise XOR (exclusive or) for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 2,805;
category: Funzioni Aggregative
This MySQL function returns the position where search_value would be located in a comma-separated list of ordered_value arguments.
page views: 2,944;
category: Funzioni Stringa
This MySQL function returns the square root of its input, which must be a positive number.
page views: 3,062;
category: Funzioni Matematiche
CASE
This MySQL function produces results that vary based on which condition is true. It is similar to the IF( ) function except that multiple conditions and results may be strung together.
page views: 2,748;
category: Controllo Flusso
Use this MySQL function to determine whether the value of the argument given in parentheses is NULL. It returns 1 if the value is NULL and 0 if it is not NULL.
page views: 3,437;
category: Controllo Flusso
This MySQL function returns the population standard deviation of the given column.
page views: 2,943;
category: Funzioni Aggregative
CAST( )
Use this MySQL function to convert a value from one datatype to another.
page views: 2,823;
category: Funzioni Stringa
Use this MySQL function to determine whether the name of the lock given in parentheses is free and available as a lock name.
page views: 6,877;
category: Tavola e Server Istruzione Amministrazione
This MySQL function returns the population standard deviation of the given column.
page views: 2,894;
category: Funzioni Aggregative
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 3,062;
category: Funzioni Matematiche
This MySQL function determines whether the name given is already in use as a lock name.
page views: 3,314;
category: Tavola e Server Istruzione Amministrazione
This MySQL function returns the population standard deviation of the given column.
page views: 3,157;
category: Funzioni Aggregative
CEILING( )
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 2,616;
category: Funzioni Matematiche
This MySQL function returns the date of the last day of the month for a given date or datetime value.
page views: 11,871;
category: Funzioni Data e Ora
This MySQL function returns the sample standard deviation of the given column.
page views: 3,094;
category: Funzioni Aggregative
This MySQL function returns a string corresponding to the numeric code passed as the argument.
page views: 3,083;
category: Funzioni Stringa
This MySQL function converts a string given to all lowercase letters.
page views: 3,534;
category: Funzioni Stringa
This MySQL function compares two strings to determine whether the first string is before or after the second string in ASCII sequence.
page views: 5,848;
category: Funzioni Stringa
CHARACTER_LENGTH( )
This MySQL function returns the number of characters of a given string.
page views: 2,751;
category: Funzioni Stringa
LEAST( )
Use this MySQL function to compare two or more values and return the smallest value.
page views: 2,712;
category: Funzioni Matematiche
This MySQL function returns the date and time of a given string for a given format.
page views: 3,174;
category: Funzioni Data e Ora
CHARSET( )
This MySQL function returns the character set used by a given string.
page views: 2,554;
category: Funzioni Stringa
This MySQL function returns the first length characters from a string.
page views: 3,556;
category: Funzioni Stringa
Use this MySQL function to subtract a date or time interval from the results of a DATE or TIME data type column. It's an alias for DATE_SUB( ).
page views: 3,762;
category: Funzioni Data e Ora
This MySQL function returns the number of characters in a given string.
page views: 5,027;
category: Funzioni Stringa
LENGTH( )
This MySQL function returns the number of bytes contained in a given string.
page views: 2,662;
category: Funzioni Stringa
This MySQL function is an alias of SUBSTRING().
page views: 2,945;
category: Funzioni Stringa
This MySQL function returns the leftmost non-NULL string or column in a comma-separated list.
page views: 2,935;
category: Funzioni Stringa
LN( )
This MySQL function returns the natural logarithm of its input.
page views: 2,724;
category: Funzioni Matematiche
This MySQL function returns the characters of a given string, starting from the position given.
page views: 3,651;
category: Funzioni Stringa
This MySQL function returns an arbirary value known as the coercibility of a given string or other item, determning how likely that item is to determine the collation used in
page views: 3,066;
category: Funzioni Stringa
This MySQL function reads the contents of a file and returns it as a string that may be used in MySQL statements and functions.
page views: 3,119;
category: Funzioni Stringa
This MySQL function returns a substring of string, using delimiter to separate substrings and count to determine which of the substrings to return.
page views: 4,262;
category: Funzioni Stringa
COLLATION( )
This MySQL function returns the collation for the character set of a given string.
page views: 2,626;
category: Funzioni Stringa
This MySQL function returns the current system date in yyyy-mm-dd hh:mm:ss format. It's synonymous with LOCALTIMESTAMP( ) and NOW( ).
page views: 2,878;
category: Funzioni Data e Ora
This MySQL function returns the date and time for the given string or column, decreased by the time given as the second argument (d hh:mm:ss).
page views: 7,600;
category: Funzioni Data e Ora
COMPRESS( )
This MySQL function returns a given string after compressing it.
page views: 2,683;
category: Funzioni Stringa
LOCALTIMESTAMP( )
This MySQL function is synonymous with LOCALTIME( ) and NOW( ).
page views: 2,816;
category: Funzioni Data e Ora
This MySQL function returns the sum of the values for the given column or expression.
page views: 3,107;
category: Funzioni Aggregative
With this MySQL function, strings or columns can be concatenated or pasted together into one resulting field.
page views: 5,226;
category: Funzioni Stringa
This MySQL function returns the numeric starting point of the first occurrence of a substring in the string supplied as a second argument.
page views: 5,142;
category: Funzioni Stringa
This MySQL function returns the system date in the yyyy-mm-dd hh:mm:ss format at the time it's executed.
page views: 6,359;
category: Funzioni Data e Ora
CONNECTION_ID( )
This MySQL function returns the MySQL connection or thread identification number for the MySQL session.
page views: 2,592;
category: Tavola e Server Istruzione Amministrazione
LOG( )
This MySQL function returns the logarithm of the first argument to the base indicated by the second argument.
page views: 2,782;
category: Funzioni Matematiche
Questa funzione MySQL restituisce il nome utente e il nome host per la connessione corrente MySQL. La funzione non ha argomenti.
page views: 4,440;
category: Istruzione di Utente e Sicurezza
This MySQL function converts a number from one numeric base system to another.
page views: 2,872;
category: Funzioni Matematiche
LOG10( )
This MySQL function returns the base 10 logarithm of a given number.
page views: 2,666;
category: Funzioni Matematiche
This MySQL function returns the tangent of an angle, where number is expressed in radians.
page views: 2,888;
category: Funzioni Matematiche
CONVERT( )
Use this MySQL function to convert the character set of a given string to another character set specified with the USING keyword.
page views: 2,685;
category: Funzioni Stringa
LOG2( )
This MySQL function returns the base-two logarithm of a given number.
page views: 2,617;
category: Funzioni Matematiche
This MySQL function returns the time from a given string or column containing date and time data.
page views: 3,125;
category: Funzioni Data e Ora
This MySQL function converts a date and time for given time zone to another which is specified.
page views: 5,453;
category: Funzioni Data e Ora
LOWER( )
This MySQL function converts a string given to all lowercase letters.
page views: 2,749;
category: Funzioni Stringa
This MySQL function returns the time difference between the two times given.
page views: 3,208;
category: Funzioni Data e Ora
COS( )
This MySQL function returns the cosine of number, where number is expressed in radians.
page views: 2,821;
category: Funzioni Matematiche
This MySQL function adds padding to the left end of string, stopping if the combination of string and the added padding reach length characters.
page views: 3,802;
category: Funzioni Stringa
TIMESTAMP( )
This MySQL function merges the date and time from given strings or columns that contain date and time data separately; the result is returned in yyyy-mm-dd hh:mm:ss format.
page views: 2,736;
category: Funzioni Data e Ora
COT( )
This MySQL function returns the cotangent of a number.
page views: 2,705;
category: Funzioni Matematiche
LTRIM( )
This MySQL function returns the given string with any leading spaces removed.
page views: 2,819;
category: Funzioni Stringa
This MySQL function adds the given number of intervals of time to the given date or time.
page views: 7,391;
category: Funzioni Data e Ora
This MySQL function returns the number of rows retrieved in the SELECT statement for the given column.
page views: 4,059;
category: Funzioni Aggregative
This MySQL function determines the date requested from the start of the given year, by adding the number of days given.
page views: 3,565;
category: Funzioni Data e Ora
This MySQL function returns the time difference between the two times given, but only for the interval being compared.
page views: 4,815;
category: Funzioni Data e Ora
CRC32( )
This MySQL function returns the given string's cyclic redundancy check value as a 32-bit unsigned value.
page views: 2,678;
category: Funzioni Stringa
This MySQL function converts a given hour, minute, and second to hh:mm:ss format.
page views: 2,866;
category: Funzioni Data e Ora
This MySQL function returns the time value of the time element provided and formats it according to formatting codes given.
page views: 3,525;
category: Funzioni Data e Ora
This MySQL function returns the current system date in yyyy-mm-dd format.
page views: 4,400;
category: Funzioni Data e Ora
This MySQL function converts the decimal number in bits to binary and returns a comma-separated list of values for all the bits that are set in that number, using string1 for the low-
page views: 3,373;
category: Funzioni Stringa
This MySQL function returns the number of seconds that the given time represents.
page views: 5,017;
category: Funzioni Data e Ora
This MySQL function is the same as CURDATE().
page views: 2,981;
category: Funzioni Data e Ora
This MySQL function is used only for columns indexed by a FULLTEXT index, and only in WHERE clauses.
page views: 3,214;
category: Funzioni Stringa
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 3,055;
category: Funzioni Data e Ora
This MySQL function returns the current time in hh:mm:ss format. This is synonymous with CURTIME( ).
page views: 2,894;
category: Funzioni Data e Ora
MAX( )
This MySQL function returns the highest number in the values for a given column.
page views: 2,816;
category: Funzioni Aggregative
This MySQL function returns the given string with any trailing or leading padding removed, depending on which is specified.
page views: 12,328;
category: Funzioni Stringa
This MySQL function returns the current date and time in yyyy-mm-dd hh:mm:ss format.
page views: 3,074;
category: Funzioni Data e Ora
Questa funzione MySQL utilizza un MD5 checksum a 128 bit per restituire un valore di 32 caratteri hash della stringa dallo standard RFC 1321.
page views: 3,115;
category: Istruzione di Utente e Sicurezza
TRUNCATE( )
This MySQL function returns a number equivalent to its first argument, removing any digits beyond the number of decimal places specified in the second argument.
page views: 2,667;
category: Funzioni Matematiche
CURRENT_USER( )
Questa funzione MySQL restituisce il nome utente e l'host che sono stati dati da parte dell'utente per la connessione corrente MySQL.
page views: 2,702;
category: Istruzione di Utente e Sicurezza
This MySQL function extracts the microseconds value of a given time.
page views: 4,155;
category: Funzioni Data e Ora
This MySQL function converts a string given to all uppercase letters.
page views: 3,587;
category: Funzioni Stringa
This MySQL function returns the current system time in hh:mm:ss format.
page views: 3,535;
category: Funzioni Data e Ora
This MySQL function returns the characters of a given string, starting from the position specified in the second argument.
page views: 3,581;
category: Funzioni Stringa
UNCOMPRESS( )
This MySQL function returns the uncompressed string corresponding to the compressed string given, reversing the results of the COMPRESS( ) function.
page views: 2,782;
category: Funzioni Stringa
DATABASE( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,710;
category: Altri Funzioni
MIN( )
This MySQL function returns the lowest number in the values for a given column.
page views: 2,821;
category: Funzioni Aggregative
UNCOMPRESSED_LENGTH( )
This MySQL function returns the number of characters contained in the given compressed string before it was compressed.
page views: 2,442;
category: Funzioni Stringa
DATE( )
This MySQL function returns the date from a given string, value, or expression that is submitted in a date or datetime format.
page views: 2,852;
category: Funzioni Data e Ora
This MySQL function returns the minute value (0-59) of a given time.
page views: 3,780;
category: Funzioni Data e Ora
This MySQL function converts hexadecimal numbers to their character equivalents.
page views: 3,804;
category: Funzioni Stringa
This MySQL function returns the number of days of difference between the two dates given.
page views: 3,058;
category: Funzioni Data e Ora
MOD( )
This MySQL function returns the remainder of a number given in the first argument when divided by the number given in the second argument, the modulo.
page views: 2,728;
category: Funzioni Matematiche
UNIX_TIMESTAMP( )
This MySQL function returns the number of seconds since the start of the Unix epoch (January 1, 1970, Greenwich Mean Time).
page views: 2,816;
category: Funzioni Data e Ora
Using the date or datetime given, this MySQL function adds the number of intervals specified. It's fairly synonymous with the ADDDATE( ) function.
page views: 5,911;
category: Funzioni Data e Ora
This MySQL function returns the numeric value of the month (0-12) for the date provided.
page views: 3,769;
category: Funzioni Data e Ora
UPPER( )
This MySQL function converts a given string to all uppercase letters.
page views: 2,803;
category: Funzioni Stringa
This MySQL function returns a date and time in a desired format, based on formatting codes listed within quotes for the second argument of the function.
page views: 4,472;
category: Funzioni Data e Ora
This MySQL function returns the name of the month for the date provided.
page views: 5,797;
category: Funzioni Data e Ora
USER( )
Questa funzione MySQL restituisce il nome utente e il nome host per la connessione corrente MySQL. La funzione non ha argomenti.
page views: 1,361;
category: Istruzione di Utente e Sicurezza
Use this MySQL function to subtract from the results of a date or time data type column. It's fairly synonymous with the SUBDATE( ).
page views: 4,436;
category: Funzioni Data e Ora
This MySQL function returns the current date and time. The format returned is yyyy-mm-dd hh:mm:ss.nnnnnn. It's synonymous with LOCALTIME( ) and LOCALTIMESTAMP( ).
page views: 3,802;
category: Funzioni Data e Ora
This MySQL function returns the current Universal Time, Coordinated (UTC) date in yyyy-mm-dd format.
page views: 3,001;
category: Funzioni Data e Ora
DAY( )
This MySQL function returns the day of the month for a given date.
page views: 2,824;
category: Funzioni Data e Ora
This MySQL function returns NULL if the two arguments given are equal. Otherwise, it returns the value or results of the first argument.
page views: 2,868;
category: Controllo Flusso
This MySQL function returns the current Universal Time, Coordinated (UTC) time in hh:mm:ss format.
page views: 2,910;
category: Funzioni Data e Ora
This MySQL function returns the name of the day for the date provided.
page views: 3,891;
category: Funzioni Data e Ora
OCT( )
This MySQL function returns the octal or base 8 numeric system value of the given number.
page views: 2,833;
category: Funzioni Matematiche
This MySQL function returns the current UTC date and time in yyyy-mm-dd hh:mm:ss format.
page views: 4,779;
category: Funzioni Data e Ora
This MySQL function returns the day of the month for the date given.
page views: 3,779;
category: Funzioni Data e Ora
OCTET_LENGTH( )
This MySQL function returns the number of bytes contained in the given string.
page views: 2,740;
category: Funzioni Stringa
UUID ( )
This MySQL function returns a Universal Unique Identifier (UUID), a 128-bit number composed of five hexadecimal numbers.
page views: 2,820;
category: Altri Funzioni
This MySQL function returns the numerical day of the week for a given date.
page views: 3,784;
category: Funzioni Data e Ora
OLD_PASSWORD( )
Questa funzione MySQL crittografa una data stringa basata sul metodo di crittografia password utilizzata prima della versione 4.1 di MySQL. Il risultato non può essere decifrato.
page views: 2,467;
category: Istruzione di Utente e Sicurezza
With this MySQL function the variance is determined by taking the difference between each given value and the average of all values given.
page views: 5,633;
category: Funzioni Aggregative
This MySQL function returns the day of the year. January 1 would give a value of 1.
page views: 2,927;
category: Funzioni Data e Ora
This MySQL function returns an ordinal value, the position of a character in the ASCII character set of the left-most character in a given string.
page views: 3,161;
category: Funzioni Stringa
This MySQL function returns the variance of a given column, based on the rows selected as a population.
page views: 3,162;
category: Funzioni Aggregative
Questa funzione MySQL decifra una stringa dato che è stato crittografato con una password fornita.
page views: 3,125;
category: Istruzione di Utente e Sicurezza
Questa funzione MySQL crittografa una password dato per un argomento. Il risultato non può essere decifrato.
page views: 4,474;
category: Istruzione di Utente e Sicurezza
This MySQL function returns the variance of a given column, based on the rows selected as a sample of a given population.
page views: 2,879;
category: Funzioni Aggregative
DEGREES( )
This MySQL function converts radians to degrees.
page views: 2,627;
category: Funzioni Matematiche
This MySQL function adds a specified number of months to a period, which is a string containing only the year and month in either yyyymm or yymm format.
page views: 3,022;
category: Funzioni Data e Ora
VERSION( )
This MySQL function returns the MySQL server version.
page views: 2,708;
category: Altri Funzioni
Questa funzione MySQL decifra testo che è stato crittografato utilizzando l'algoritmo triplo DES con 128 bit di lunghezza chiave, invertendo la funzione <a href='/documentation/user-secur
page views: 3,284;
category: Istruzione di Utente e Sicurezza
This MySQL function returns the number of months between periods given.
page views: 3,551;
category: Funzioni Data e Ora
This MySQL function returns the number of the week starting from the beginning of the year for the date provided.
page views: 4,172;
category: Funzioni Data e Ora
Questa funzione MySQL restituisce testo cifrato con l'algoritmo triplo DES algoritmo con 128 bit di lunghezza chiave.
page views: 4,614;
category: Istruzione di Utente e Sicurezza
PI( )
This MySQL function returns by default the first five decimal places of the number pi.
page views: 2,685;
category: Funzioni Matematiche
This MySQL function returns the number for the day of the week. Monday is considered the first day of the week.
page views: 3,089;
category: Funzioni Data e Ora
ELT( )
This MySQL function returns the index element from the list of strings given, where the list is numbered starting with 1.
page views: 2,856;
category: Funzioni Stringa
POSITION( )
This MySQL function returns index of the character in string where substring first appears.
page views: 2,560;
category: Funzioni Stringa
WEEKOFYEAR( )
This MySQL function returns the calendar week of the year for a given date. It's a bit synonymous with WEEK( ).
page views: 2,751;
category: Funzioni Data e Ora
Questa funzione MySQL cripta una stringa di dato in formato binario e blocca con la password.
page views: 4,369;
category: Istruzione di Utente e Sicurezza
POW( )
This MySQL function returns the result of raising the number given in the first argument to the exponent given in the second argument.
page views: 2,739;
category: Funzioni Matematiche
This MySQL function returns the year of the date provided.
page views: 3,386;
category: Funzioni Data e Ora
ENCRYPT( )
Questa funzione MySQL restituisce testo cifrato utilizzando il linguaggio C funzione di cripta.
page views: 2,514;
category: Istruzione di Utente e Sicurezza
POWER( )
This MySQL function returns the result of raising the number given in the first argument to the power of the number given in the second argument.
page views: 2,727;
category: Funzioni Matematiche
This MySQL function returns the year coupled with the number of the week into the year: yyyyww. By default, the first day of the week is Sunday and the basis of the calculation.
page views: 3,388;
category: Funzioni Data e Ora
EXP( )
This MySQL function returns the value of the natural logarithm base number e to the power of the given number.
page views: 2,731;
category: Funzioni Matematiche
This MySQL function returns the number of the quarter (1-4) for the date provided. The first quarter (i.e., three months) of each year has a value of 1.
page views: 6,414;
category: Funzioni Data e Ora