All about MySQL

mysqlbloggers.com

Home Learn MySQL ZenCart Blogs

Database Table

September 28, 2008

How do I get the number of rows of each type with MySQL?

mysql
Anonymous asked:


I have a database table with two fields: id (an unique numerical identifier) and type (a string). I would like to count the number of occurrences of each of the possible values of ‘type’. Is there an easy way of doing this with MySQL?

Tags: Database Table, Mysql Database, Numerical Identifier

Filed under Programming & Design by administrator

Permalink Print 2 Comments
  • Archives

    • March 2009
    • February 2009
    • January 2009
    • December 2008
    • November 2008
    • October 2008
    • September 2008
  • Tags

    Acquisition Apache Apache Php Backup Mysql Create Database Databases Knowledge Linux Microsoft Access Mysql Mysql And Php Mysql Data Mysql Database Mysql Databases Mysql Db Mysql Delphi Mysql Help Mysql Hosting Mysql Odbc Mysql Php Mysql Query Mysql Server Mysql Tutorial Mysql Windows Oracle php Php And Mysql Php Apache Php Database Php Form Phpmyadmin Php Mysql Php Tutorials Php Windows Running Servers String Text Tool Tutorial Mysql Ulbra Upload Upload Images Web Application Web Server Yahoo
  • Categories

    • Comedy
    • Computer Networking
    • Education
    • Howto
    • Music
    • News
    • Other - Internet
    • People
    • Programming & Design
    • Security
    • Software
    • Studying Abroad
    • Tech
    • Travel
Copyright 2010
Home