Re: need some help with a stored procedure to import XML into a table

[Rick James]

Let's see the actual .sh file.

It would be easier, clear, simplier, etc, if you used a heredoc, and use it for the input, not "-e", something like:

cat <<ZZZ >sql.txt
use test;
set @xml :=(XML/$xmlFILENAME);
delimiter //
drop procedure if exists p_temp
...
ZZZ
mysql -u root -ppassword -D tempDB -X <sql.txt

Check the syntax rules for interpolating $ variables in such; I forget the details. That, plus multi-line quoting were probably your problems.

Why have this at all? @xml does not seem to be used.
echo "set @xml :=(XML/$xmlFILENAME);" >> sqlcommand.sh