取第一个逗号前的串:
select left(col1,instr(col1,",")) a from tablename
分隔逗号插入到新表:
strArray = split(str,",")
for i=0 to unbound(strArray)-1
conn.execute("insert tablename(col1,col2) values(1,strArray(i)))
next
取第一个逗号前的串:
select left(col1,instr(col1,",")) a from tablename
分隔逗号插入到新表:
strArray = split(str,",")
for i=0 to unbound(strArray)-1
conn.execute("insert tablename(col1,col2) values(1,strArray(i)))
next