Sunday, September 19, 2010

Quick Tip: Working with MySQL and SUM

Quick Tip: Working with MySQL and SUM: "


In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also provide a performance improvement.






"
Post a Comment

How to mount an ISO file in ubuntu?

Maybe, instead of installing additional software, you can use what the system has to this end: Create a directory to serve as the mount ...