MySQL 中怎么通过SUBSTRING_INDEX函数拆分字符串为数组单元

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

vim test.sh#Define variablesMYSQL_HOME=/usrSQL_SCRIPT_DB_CONNECTION_STRING='-uroot -p'root''SQL_SCRIPT_PARAMETERS_LIST="'PARAM1 PARAM2 PARAM3'"#Execute the command#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; /* define the total number of the variables  */ set @VAR_POS=0; /* define the variable position in the string *//* define the variables' value, if the the variable doesn't exist, its value is null  */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;"sh test.sh Warning: Using a password on the command line interface can be insecure.+--------+--------+--------+--------+--------+--------+--------+| @VAR_1 | @VAR_2 | @VAR_3 | @VAR_4 | @VAR_5 | @VAR_6 | @VAR_7 |+--------+--------+--------+--------+--------+--------+--------+| PARAM1 | PARAM2 | PARAM3 | NULL   | NULL   | NULL   | NULL   |+--------+--------+--------+--------+--------+--------+--------+

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