Skip to content

Tag Archives: mysql

SUM() function : This function in MySQL is used to compute the sum of the specified group of values. Features : This function is used… Read More
An ENUM is a string object whose value is decided from a set of permitted literals(Values) that are explicitly defined at the time of column… Read More
With the help of STD() function we can calculate population Standard deviation of an expression in MySQL. But, if there are no matching rows in… Read More
STRCMP() function in MySQL is used to compare two strings. If both of the strings are same then it returns 0, if the first argument… Read More
FROM_DAYS() : This function is used to return the date from a specified numeric date value. Here specified date value is divided by 365 and… Read More
NOW() : This function in MySQL is used to check the current date and time value. The return type for NOW() function is either in… Read More
Sometimes we need to calculate population Standard variance of an expression in MySQL. VARIANCE() function can be used for this purpose in MySQL. It returns… Read More
FIELD() function : This function in MySQL is used to return the index position of a specified value in a list of given values. For… Read More
The purpose of this article is to make a simple program to create a leaderboard using PHP. Below is the implementation for the same using… Read More
VAR_SAMP() function in MySQL is used to calculate sample variance of an expression. Syntax : VAR_SAMP(expr); Parameter : This method accepts only one parameter. expr… Read More
FIELD() : This function helps in returning the position of a value in the given value list. If the user passes string values as the… Read More
EXPORT_SET() : This function helps to return a string which will show the bits in number. The function requires 5 arguments for its functioning. The… Read More
VAR_POP() function in MySQL is used to calculate population standard variance of an expression. Syntax : VAR_POP(expr); Parameter : This method accepts only one parameter.… Read More
STDDEV_SAMP() function in MySQL is used to calculate sample standard deviation of an expression. Syntax : STDDEV_SAMP(expr); Parameter : This method accepts only one parameter.… Read More
Sometimes we need to calculate population Standard deviation of an expression in MySQL. STDDEV() function can be used for this purpose in MySQL. It returns… Read More

Start Your Coding Journey Now!