mysql 分割字符添加入多个字段

SELECT LOCATE(';',column_0) FROM split;

SELECT SUBSTRING(column_0,1,LOCATE(';',column_0)-1) FROM split;

SELECT SUBSTRING(column_0,LOCATE(';',column_0)+1) FROM split;

UPDATE  split SET column_1=SUBSTRING(column_0,1,LOCATE(';',column_0)-1),column_5=SUBSTR(column_0,LOCATE(';',column_0)+1)

UPDATE  split SET column_2=SUBSTRING(column_5,1,LOCATE(';',column_5)-1),column_5=SUBSTR(column_5,LOCATE(';',column_5)+1)