Modifying data in the database via script?

Share your Projects! Scripts
2

Hi @swetzel, i don’t think HA can do this.
I’m running a bash script via cron to remove such values on mysql database.

#!/bin/bash

HOST='mysql_server'
DB='HA_DB'
USER='username'
PW='password'

query="DELETE FROM states where state like '%999%'"
echo "$query" | mysql -h$HOST -D$DB -u$USER -p$PW

query="DELETE FROM states where state like '%unknown%'"
echo "$query" | mysql -h$HOST -D$DB -u$USER -p$PW