awk 语句

awk  -F ',' '{print "update tblClassInfo set class_type = 1, ext = 47{"class_name":""$3"", "teacher_name":""$4""}47 where class_code = "$1";"}' 1.txt

1,1,哈哈哈,呃呃呃
2,2,哈哈哈,呃呃呃呃
3,3,dsad,cxcxzc
4,4,fdsafdsa,fdsafsafds

 下面这条sql语句在输出的时候总是输出错误，后来发现是$3后面有换行符导致的，这一点以后要注意，不要粗心了。

awk  -F ',' '{print "insert into tblClassUserConfs(cate, uid, create_time, update_time, ext) value (1, "$3", 1595246294, 1595246294, 47{"email":""$1""}47) on duplicate key update ext = 47{"email":""$1""}47;"}' 1.txt