역시 구글은 개발자의 친구~ 유후~
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# drop-db.sh
DB_STARTS_WITH='sample_' # sample_table1, sample_table2...
MUSER=""
MPWD=""
MYSQL="mysql"
DBS="$($MYSQL -u$MUSER -p$MPWD -Bse 'show databases')"
for db in $DBS; do
if [[ "$db" =~ ^$PDB_STARTS_WITH}" ]]; then
echo "Deleting $db"
$MYSQL -u$MUSER -p$MPWD -Bse "drop database $db"
fi
done