Author: Hashim

List are a way of representing things in a chronological manner.Sometime we use it to show the hierarchy also. List can be of two types : Ordered List , UnOrdered Listfirst published! (required) Ordered List in HTML Cricket Playing nations India Pakistan England South Africa For above list, we have to use the below code <ol> <li>India</li> <li>Pakistan</li> <li>England</li> <li>South Africa</li> </ol> Another style for ordered list India Pakistan England South Africa For above list,…

Below is the list of GROUP functions that are basically used in Mysql Name Description AVG() Return the average value of the argument BIT_AND() Return bitwise and BIT_OR() Return bitwise or BIT_XOR() Return bitwise xor COUNT(DISTINCT) Return the count of a number of different values COUNT() Return a count of the number of rows returned GROUP_CONCAT() Return a concatenated string MAX() Return the maximum value MIN() Return the minimum value STD() Return the population standard…

If else is basically used in the programming paradigm. We can use the same in Mysql. How to use If-Else Mysql Sometime it is very useful in programming. Suppose you have two column in the table as price and discountprice in the product column. You want to fetch the price and show it in the front end. If the discount is set in the table then it will be the actual price not the value…