insert into members (name, gender, blood, age) select j1.key "name", j1.value "gender", j2.value "blood", j3.value "age" from json_each_text('{"Chris":"Male", "Kelly":"Female"}') as j1 join json_each_text('{"Chris":"A", "Kelly":"O"}') as j2 on j2.key = j1.key join json_each_text('{"Chris":"42", "Kelly":"34"}') as j3 on j3.key = j1.key
"Chris";"Male";"A";"42" "Kelly";"Female";"O";"34"JSON Functions and Operators
沒有留言:
張貼留言