GROUP functions in Mysql

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…

"GROUP functions in Mysql"

How to use If-Else in Mysql

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…

"How to use If-Else in Mysql"

Samsung Galaxy s6 vs. Apple iPhone 6s : What to Expect

The Apple iPhone 6 fans are partying hard and showing off the celebration in style. However, the neutral geeks are quite steady as usual as they are waiting for the next half of the movie, till the release of Samsung Galaxy S6, which is said to have been made strategically for answering Cupertino. On the other hand, though in near past only Apple unveiled two of its grand devices the iPhone 6, and iPhone 6 Plus,…

"Samsung Galaxy s6 vs. Apple iPhone 6s : What to Expect"

How To Force Idle Status on Google Talk

We all love chatting. Google Talk gives us freedom to talk anywhere and anytime wiht our online friends. Message them instantaneously, transfer files, share photos – we love it all. But what we don’t like is getting disturbed by some unwanted friend. We really don’t want to chat at that moment but we are forced for maintaining relations. Can we trick Google Talk? Can we show idle status and be active at the same time?…

"How To Force Idle Status on Google Talk"

Share Files from Google Drive with Others

Now with Google Drive, you can share more than one file with other people. Just send them a direct link to your files or share file with an individual’s email address or a mailing list. SHARE FILES VIA AN EMAIL ADDRESS OR MAILING LIST Access drive.google.com. Check the box next to the file or folder you want to share. Choose the “Share” icon OR Click the More menu and select “Share…” Select a visibility option: “Private,”…

"Share Files from Google Drive with Others"