clean_mysql.sh 426 B

12345678910111213141516171819
  1. #! /bin/bash
  2. . ./config.sh
  3. url=$MYSQL_URL
  4. username=$MYSQL_USER
  5. password=$MYSQL_PASSWORD
  6. del_energy_15_min="truncate table energy_15_min;"
  7. del_energy_5_min="truncate table energy_5_min;"
  8. clean_energy_15(){
  9. mysql -h${url} -P3306 -u${username} -p${password} ${result_database} -e "${del_energy_15_min}"
  10. }
  11. clean_energy_5(){
  12. mysql -h${url} -P3306 -u${username} -p${password} ${result_database} -e "${del_energy_5_min}"
  13. }