Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

How do you count the number of rows in a mysql database

Member
  
Join Date: Jun 2007
Posts: 34
#1: Jul 9 '07
How do you count the number of rows in a mysql database.

could anyone help
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 719
#2: Jul 9 '07

re: How do you count the number of rows in a mysql database

Do you mean number of rows in a table? The syntax to count rows in a table is

Expand|Select|Wrap|Line Numbers
  1. SELECT COUNT(*) FROM table_name;
Member
  
Join Date: Jun 2007
Posts: 34
#3: Jul 23 '07

re: How do you count the number of rows in a mysql database

thanks you for your help
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,366 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved