Warren Windvogel wrote:
Hi,
Can anyone tell me how to check the total number of records in a
database in MySQL version 4.0
Googling doesn't seem to help and all previous posts assume version 5.*
[...]
Something like this:
mysql -NBe'show databases' |
while IFS= read -r db; do
printf "show tables from %s;\n" "$db" |
mysql -N | while IFS= read -r t; do
printf "select count(1) from %s.%s;\n" "$db" "$t"
done
done | mysql -N |
awk '{ s += $1 }END{ print s }'
Regards
Dimitre
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]