Search Tutorials

Latest Questions

Connection pooling
Respected Sir/Madam, I am Ragavendran.R.. I got your link which u have sent for implementing connection
Timer in the code
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
My Eclipse deployed problem.
Dear All, I am facing a problem. When First time I am deploying a web project in eclipse in jboss its fine b
jsp code
how to count no of clicks made on a link and save it on database( using jsp)
Another Question
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
Connection pooling
Respected Sir/Madam, I am Ragavendran.R.. I need some clarification on what connection pooling is?
Error in a code.
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
netbeans resource prob
Hi,please can you tell me how to include a file like an image in the jar package in netbeans so that i dont need to prov
Failed to run Online Quiz Application in JSP
Hi, I have been following your following link to run the online quiz application, but I failed to get the result scre
Pass by Reference
Hi Friends, What is Pass by value and Pass by Reference?can u please explain with examples.is java supports Pass by r
All Questions...

Comments

MySQL Count
This example illustrates how to use count() in MySQL database.

MySQL Count

This example illustrates how to use count() in MySQL database.

Count(): The Count() is an aggregate function that counts all the rows in a specified table. It returns a numeric value. If you use COUNT(*) that counts the number of rows.

Table: employee

CREATE TABLE `employee` (
`emp_id` int(11) NOT NULL auto_increment,
`emp_name` varchar(10) character set utf8 NOT NULL,
`emp_salary` int(11) NOT NULL,
`emp_startDate` datetime NOT NULL,
`dep_name` varchar(50) NOT NULL,
PRIMARY KEY (`emp_id`)
)

To select all records use the query:

SELECT * FROM employee;

Output:

To use COUNT(*) with the sql query:

SELECT COUNT(*) FROM employee;

Output:

To use COUNT(column_name) with the GROUP BY sql query:

You can use count function on column. If it is used with group by clause then it counts all the items that are in a group. For example, the query below shows the department name and total no of employee in the department with the help of count function.

SELECT dep_name,COUNT(emp_name) As Total FROM employee GROUP BY (dep_name);

ť View all related tutorials

Related Tags: sql mysql c table sed tab if ie record records to ci e use trie pe from m tr spec

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.