如何把用逗号隔开的字符串参数传到SQL语句中

2025-03-23 14:44:47
推荐回答(1个)
回答1:

如何把用逗号隔开的字符串参数传到SQL语句中
create table table1 as select *,substr(col1,1,instr(col1,',',1)-1) as col1begin,substr(col1,instr(col1,',',1)+1,length(col1)) as col1end from table;