刪除大於30的MySQL資料（shell script）

#!/bin/sh


case $1 in

del)

DATE=`date +%Y-%m-%d\ 00:00:00 --date '1 month ago'`
SQL="mysql --login-path=client --disable-column-names -e"

$SQL  "use event;delete from api_search_log where create_time <= '$DATE'; "
echo "event.api_search_log <= $DATE delete done."

;;


db)

#找資料用
mysql --login-path=client

;;


*)

echo "Usage:$0 {del|db}"
exit 0
;;

esac