Skip to content

Instantly share code, notes, and snippets.

@josefglatz

josefglatz/count+groupby-example.sql

Created April 20, 2016 10:43
Show Gist options
  • Save josefglatz/7648d6417c59f1cac2f06e3604cd28c4 to your computer and use it in GitHub Desktop.
Save josefglatz/7648d6417c59f1cac2f06e3604cd28c4 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Count GroupBy Combo (e.g. TYPO3 Camp T-Shirt overview ;-] )
Raw
count+groupby-example.sql
# Create a database table
# Add necessary fields
# Import csv and map fields
# run if you table is named "Shirts" and the T-Shirt size column is named "Size"
SELECT Size,COUNT(*) FROM Shirts GROUP BY Size;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment