Add:
Code
Short description
Tags

Like: create mysql user Like: mysql, bash, server

public

add it or cancel

IMPORTANT!

Snipt is going open source. We've toyed with this idea for quite a while, and have finally decided it's the right way to move forward.

A few things:

The entire Snipt source code will be released on GitHub under the 3-clause BSD License on Friday, September 10th.
While we'd like to think we're perfect, we realize we're only human. By open sourcing the software that runs this website, certain bugs or security flaws may be discovered that could compromise the privacy of your snipts.
Only the Lion Burger team will be able to push commits to the Snipt.net site. Contributors should send a pull request to add new features or submit patches.
By using this site, you agree not to be too angry or take any legal action against Lion Burger should this whole thing go up in flames some day.
Follow us on Twitter for updates.

I agree, close this message

count

showing 1-1 of 1 snipts for count

∞ Count Monthly/Yearly Totals in MySQL

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

sql

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

copy | embed

0 comments - tagged in

posted by robertbanh on Jan 21, 2010 at 5:01 p.m. EST

Latest 100 public snipts » robertbanh's snipts » count

robertbanh's tags