MySQL 中怎么通过SUBSTRING_INDEX函数拆分字符串为数组单元，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

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|+--------+--------+--------+--------+--------+--------+--------+

看完上述内容，你们掌握MySQL 中怎么通过SUBSTRING_INDEX函数拆分字符串为数组单元的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！