user='########'
pass='########'
host='########'
database='########'
sleep=1

#id=777777
limit=10000

commands=(
'delete from table_name limit '$limit
#'delete from table_name where column_name < '$id' limit '$limit
)

for i in "${commands[@]}"
do

echo "Applying $i"

	while [[ $(mysql -vv -u$user -p$pass -h$host -e "$i" --skip-column-names $database) != *" 0 rows affected"* ]]
		do
  		printf "#"
  		sleep $sleep
	done

echo "Command Finished!"

done