The Joys of COUNT

10th May 2006 11:50 | Categories: SQL, HowTo

COUNT has actually two forms: COUNT(*) counts the number of rows in a table; and COUNT(expr) counts the non-null occurrences of expr. This is very useful for generating reports, e.g.:

SELECT COUNT(*) AS 'Total', COUNT(ID_winner) AS 'Claimed'

gotofritz.net — reviews and media technology

Email | Resume

This is a post within the site. You can navigate through posts via the links labelled 'next', or click on 'search/sitemap' at the top right handside of the page to navigate more quickly.

RSS

Fritz is an Italian chap who's been living and working in London for almost 20 years.

He's currently technical director for an integrated digital agency.

In the past he's been a chef, a musician, and author of comics.

home

Finding files on the command line and doing something with them

2006-05-11 11:47 | Tags *NIX, HowTo

find a_directory -iname "*.zip" -exec unzip -d another_directory {} \; This will unzip all files from a_directory into another_directory find a_directory -iname ...