Powered By Blogger

Wednesday, 1 June 2011

To count no of records in each table

The command is used to count the no of records for each table

mysqlshow -u kiran -pkiran testdb  --count | sort -k6nr

The command is used to count the no of records of all databases :

mysqlshow -u kiran -pkiran  --count | sort -k6nr

No comments:

Post a Comment