当mysql表中有超过50行时，编写一个shell脚本来显示警报

Question

我在MySQL中有一个表，我想显示一个警报或消息，告诉我的记录是否超过50行。

Answer 1

#!/bin/sh
mysql -u root -pflash  << EOF
use workers;
SELECT * FROM Persons;
SELECT pid,name FROM Persons WHERE gender="F";
SELECT pid,name FROM Persons WHERE gender="M";
SELECT pid FROM Persons ORDER BY pid DESC LIMIT 1;

commit;
EOF
if [[ $(mysql -u root -p -e "select COUNT(pid) from workers.Persons" | grep -E '[[:digit:]]+') -gt "5" ]]
then 
echo "Rows are greater then 50"
fi

Answer 2

运行一个查询来统计表中的条目，然后使用grep来解析输出。

if [ $(mysql --user=<username> --password=<password> -e "select COUNT(<primary key>) from <database>.<table>" | grep -E '[[:digit:]]+') -gt "50" ];
then 
echo "Rows are greater then 50";
fi