#! /bin/bash . ./config.sh url=$MYSQL_URL username=$MYSQL_USER password=$MYSQL_PASSWORD del_energy_15_min="truncate table energy_15_min;" del_energy_5_min="truncate table energy_5_min;" clean_energy_15(){ mysql -h${url} -P3306 -u${username} -p${password} ${result_database} -e "${del_energy_15_min}" } clean_energy_5(){ mysql -h${url} -P3306 -u${username} -p${password} ${result_database} -e "${del_energy_5_min}" }