我现在有这样的数据
612,2018,10,1,612,44638994,**select col1,col2,col3 from table**,2018-10-22 02:49:28.95
其中加粗的select 语句是一个字段。我想把这样的数据写成insert 语句
如:
insert into tablename values ('612','2018','10','1','612 ','44638994' ,'select col1,col2,col3 from table','2018-10-22 02:49:28.948);
请问要如何写呢?column 数量是不确定的。原本是这样写的:
while read line
do
echo $line | sed "s/^/insert into ${SCHEMA_NM.TABLE_NM} values (\'/g; s/$/\');/g; s/,/\',\'/g"
done < ${SCHEMA_NM.TABLE_NM}.csv
但是这是用逗号作为分隔符的,如果数据里面有逗号,就不适用了,求指教!