#!/bin/bash
for i in `mysql -uloguser -p123456 -e "use Syslog;show tables;" 2>/dev/null | grep "^SystemEvents_2021_02_"`
do
{
mysql -uloguser -p12346 -e "use Syslog;drop table $i;" 2>/dev/null && echo "$i drop success !"
}
done
#!/bin/bash
for i in `mysql -uloguser -p123456 -e "use Syslog;show tables;" 2>/dev/null | grep "^SystemEvents_2021_02_"`
do
{
mysql -uloguser -p12346 -e "use Syslog;drop table $i;" 2>/dev/null && echo "$i drop success !"
}
done