Tag Archives: mysql

CEILING() function :This function in MySQL is used to return the smallest integer value that is greater than or equal to a specified number. For… Read More
BIT_COUNT() function in MySQL is used to return the number of bits that are active in the given input. Active bits can be counted as… Read More
AVG() function : This function in MySQL is used to return the average value of the specified expression. Features : This function is used to… Read More
Confidentiality, integrity, and availability are the stamps of database security. Authorization is the allowance to the user or process to access the set of objects.… Read More
COUNT() function : This function in MySQL is used to find the number of indexes as returned from the query selected. Features : This function… Read More
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