MySQL Group By

by Anuj Kumar

---

Data can be grouped by “group by” key-word.

group by FieldName;

tbllibrary table structure and current status of the tbllibrary.

select * from tbllibrary;

Group by the writer and count the records for each writer.

select writer, count(*) from tbllibrary group by writer;

Explanation

There are four groups by “writer” in the table “tbllibrary”;

Share

Tags: MySQL Group By

---

• Next story PHP CRUD Operation using Stored Procedure
• Previous story Online Magazine Management System using PHP and MySQL

You may also like...

---

• 

  How To Create a MySQL New User and Grant Permissions in Linux

• 

  How to fix Error: MySQL shutdown unexpectedly

• 

  MySQL NULL Values

• 

  MySQL LIMIT

• 

  MySQL LIKE

• 

  MySQL Between Operator

• 

  MySQL Order By

• 

  MySQL AND, OR, IN, NOT IN

• 

  MySQL Where Clause

• 

  MySQL SELECT DISTINCT

• 

  How to use mysql through cmd

• 

  How to Connect PHP with MySQL Database

• 

  MySQL Select Query

• 

  MySQL Insert Into

• 

  MySQL Altering tables

• 

  MySQL Column Modifiers

• 

  MySQL Database and Tables

• 

  MySQL Data Type

• 

  MySQLi Procedural Functions

• 

  MySQL PHP Connections

• 

  MySQL Users

• 

  MySQL GUI Tools

• 

  MySQL Command-line

• 

  MySQL Introduction