笨招,不适合很多名称在一个字段里:
select T.id,
substr(T.name, 1, Instr(T.name, '.', 1) - 1) as name
from 表 t
union
select T.id,
substr(substr(T.name, Instr(T.name, '.', 1) + 1),
1,
Instr(substr(T.name, Instr(T.name, '.', 1) + 1), '.', 1) - 1) as name
from 表 t
union
select T.id,
substr(T.name, Instr(T.name, '.', 8) + 1) as name
from 表 t