mysql 同表中一个字段根据“/”拆成两个字段,然后赋给其他两个字段

第一个：UPDATE tb_associator,(SELECT username d,SUBSTRING_INDEX(USERADDRESS, "/", 1) c from tb_associator) b SET tb_associator.username=b.c where tb_associator.username =b.d;

这个就是

第二个字段：UPDATE tb_associator,(SELECT username d,REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(USERADDRESS, "/", 2)), "/", 1)) c from tb_associator) b SET tb_associator.username=b.c where tb_associator.username =b.d;