Mysql

MySQL Group By

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

group by FieldName;

1	group by FieldName;

tbllibrary table structure and current status of the tbllibrary.

select * from tbllibrary;

1	select * from tbllibrary;

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

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

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

Explanation

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

Tags: MySQL Group By

Anuj Kumar

Hi! I am Anuj Kumar, a professional web developer with 5+ years of experience in this sector. I found PHPGurukul in September 2015. My keen interest in technology and sharing knowledge with others became the main reason for starting PHPGurukul. My basic aim is to offer all web development tutorials like PHP, PDO, jQuery, PHP oops, MySQL, etc. Apart from the tutorials, we also offer you PHP Projects, and we have around 100+ PHP Projects for you.