12345678910111213141516171819 |
- #! /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}"
- }
|