Imad Posted April 8, 2008 Share Posted April 8, 2008 Hi guys, How on earth can I show how many records are in a database? I'm using the latest MySQL version and I use the linux shell for MySQL commands. Any help would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 8, 2008 Share Posted April 8, 2008 If you want to get total number of records in a table then it is really simple. Execute a SELECT query as below SELECT COUNT(*) FROM table Or you really want to get total number of records in a database? Quote Link to comment Share on other sites More sharing options...
Imad Posted April 8, 2008 Author Share Posted April 8, 2008 I want to get the total number of records from the database. Regards. Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 8, 2008 Share Posted April 8, 2008 Then you need to make script which should first get list of all tables in the database and then run the above query on each table. Quote Link to comment Share on other sites More sharing options...
Imad Posted April 8, 2008 Author Share Posted April 8, 2008 I see. I got to lazy to create the script so I counted them manually. lol Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.