insert values in mysql with bash script

Question

How can i connect to my db and execute the query in bash

this is my code so far:

echo "estacion: "$st;
fcha=$year2"-"$month"-"$day;
echo "fecha: "$fcha;

echo $archivoF " ==> " $rutabase"datos/obs/"$st"/"$year2"/"$archivoF;
if [ ! -d $rutabase"datos/obs/"$st"/"$year2 ]; then
  mkdir -p $rutabase"datos/obs/"$st"/"$year2;
fi
mv $archivoF $rutabase"datos/obs/"$st"/"$year2
IFS='.' read -ra tipoO <<< "$archivoF"
tipoOb=`echo "."${tipoO[1]}"."${tipoO[2]}`
query="insert into FILES (name,type,date,station) VALUES($archivoF,$tipoOb,$fcha,$st)"

echo $archivoG " ==> "$rutabase"rinex/nav/"$st"/"$year2"/"$archivoG;
if [ ! -d $rutabase"datos/nav/"$st"/"$year2 ]; then
mkdir -p $rutabase"datos/nav/"$st"/"$year2;
fi
mv $archivoG $rutabase"datos/nav/"$st"/"$year2
IFS='.' read -ra tipoN <<< "$archivoG"
tipoNa=`echo "."${tipoN[1]}`
query="insert into FILES (name,type,date_f,station) VALUES($archivoG,$tipoOb,$fcha,$st)"

any suggestions

Why do you use echo in your assignments? Just tipoOb=.${tipoO[1]} — Barmar
– Barmar, Commented Sep 19, 2016 at 15:51
It's also not necessary to keep starting and ending quotes. mv $archiveOF "${rutabase}datos/obs/$st/$year" — Barmar
– Barmar, Commented Sep 19, 2016 at 15:52

Barmar · Accepted Answer · 2016-09-19 15:54:28Z

2

To execute a query from a script, use the mysql command with the -e option.

query="insert into FILES (name,type,date,station) VALUES('$archivoF','$tipoOb','$fcha','$st')"
mysql -h dbhost -u dbuser -ppassword dbname -e "$query"

Make sure you put quotes around the values that are strings in the query.

answered Sep 19, 2016 at 15:54

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert values in mysql with bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related