vimtest.sh#DefinevariablesMYSQL_HOME=/usrSQL_SCRIPT_DB_CONNECTION_STRING='-uroot-p'root''SQL_SCRIPT_PARAMETERS_LIST="'PARAM1PARAM2PARAM3'"#Executethecommand#CMD_SQL_SCRIPT_EXECUTION=${MYSQL_HOME}/bin/mysql${SQL_SCRIPT_DB_CONNECTION_STRING}-e"set@VAR1=$SQL_SCRIPT_PARAMETERS_LIST;source${SQL_SCRIPT_FILE_LOCATION}/${SQL_SCRIPT_NAME}.sql;">>${myLogFile}${MYSQL_HOME}/bin/mysql${SQL_SCRIPT_DB_CONNECTION_STRING}-e"set@VAR=$SQL_SCRIPT_PARAMETERS_LIST;set@VAR_NUM=length(@VAR)-length(REPLACE(@VAR,'',''))+1;/*definethetotalnumberofthevariables*/set@VAR_POS=0;/*definethevariablepositioninthestring*//*definethevariables'value,ifthethevariabledoesn'texist,itsvalueisnull*/set@VAR_1=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_2=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_3=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_4=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_5=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_6=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);set@VAR_7=if(@VAR_POS<@VAR_NUM,SUBSTRING_INDEX(SUBSTRING_INDEX(@VAR,'',@VAR_POS:=@VAR_POS+1),'',-1),null);select@VAR_1,@VAR_2,@VAR_3,@VAR_4,@VAR_5,@VAR_6,@VAR_7;"shtest.shWarning:Usingapasswordonthecommandlineinterfacecanbeinsecure.+--------+--------+--------+--------+--------+--------+--------+|@VAR_1|@VAR_2|@VAR_3|@VAR_4|@VAR_5|@VAR_6|@VAR_7|+--------+--------+--------+--------+--------+--------+--------+|PARAM1|PARAM2|PARAM3|NULL|NULL|NULL|NULL|+--------+--------+--------+--------+--------+--------+--------+