#!/bin/bash
db="bats";
table="promotion";
dbHost="192.168.0.246";
dbUser="root";
dbPass="root";
result=`mysql -h $dbHost --user=$dbUser --password=$dbPass --skip-column-names -e "SELECT name FROM  $db.$table WHERE finish > now() ORDER BY promotion_key DESC"`

campanha=$(echo $result | tr " " "n")


   echo "$campanhas"