Em có 1 file json như thế này
{
"keyword": "a_1",
"other_keyword": [
"a_2",
"a_4"
],
"word": "A",
"wordform": "symbol",
"pronunciations": {
"britain": {
"prefix": "BrE",
"ipa": "eɪ",
"url": "https://www.oxfordlearnersdictionaries.com/media/english/uk_pron_ogg/a/a_1/a_1_g/a_1_gb_1_abbr.ogg"
},
"america": {
"prefix": "NAmE",
"ipa": "eɪ",
"url": "https://www.oxfordlearnersdictionaries.com/media/english/us_pron_ogg/a/a__/a__us/a__us_1.ogg"
}
},
"definitions_examples": [
{
"namespace": null,
"definitions": [
{
"definition": "used in Britain before a number to refer to a particular important road",
"examples": [
"the A34 to Newbury"
]
},
{
"definition": "used (but not in the US) before numbers which show standard metric sizes of paper",
"examples": [
"a sheet of A4 paper (= 297×210mm)",
"A3 (= 420×297mm)",
"A5 (= 210×148mm)"
]
}
]
}
],
"extra_examples": [],
"idioms": [],
"other_results": [
{
"All matches": [
{
"text": "A",
"keyword": "a_2",
"wordform": "abbreviation"
},
{
"text": "a",
"keyword": "a_3",
"wordform": "indefinite article"
},
{
"text": "A",
"keyword": "a_4",
"wordform": "noun"
},
{
"text": "a-",
"keyword": "a_5",
"wordform": "prefix"
},
{
"text": "amp",
"keyword": "amp#amp__29",
"wordform": "noun"
},
{
"text": "a/c",
"keyword": "a-c",
"wordform": "abbreviation"
},
{
"text": "n/a",
"keyword": "n-a",
"wordform": "abbreviation"
},
{
"text": "à la",
"keyword": "a-la",
"wordform": "preposition"
},
{
"text": "A-OK",
"keyword": "a-ok_1",
"wordform": "adverb"
},
{
"text": "A-OK",
"keyword": "a-ok_2",
"wordform": "adjective"
},
{
"text": "A & E",
"keyword": "a-e",
"wordform": "abbreviation"
},
{
"text": "A & R",
"keyword": "a-r",
"wordform": "abbreviation"
},
{
"text": "DVD-A",
"keyword": "dvd-a",
"wordform": "noun"
},
{
"text": "a tad",
"keyword": "a-tad",
"wordform": "adverb"
},
{
"text": "A-bomb",
"keyword": "a-bomb",
"wordform": "noun"
},
{
"text": "A-line",
"keyword": "a-line",
"wordform": "adjective"
},
{
"text": "A-list",
"keyword": "a-list",
"wordform": "adjective"
},
{
"text": "A-road",
"keyword": "a-road",
"wordform": "noun"
},
{
"text": "A-side",
"keyword": "a-side",
"wordform": "noun"
},
{
"text": "A-team",
"keyword": "a-team",
"wordform": "noun"
}
]
},
{
"Phrasal verbs": [
{
"text": "play A off against B",
"keyword": "play-a-off-against-b",
"wordform": "phrasal verb"
},
{
"text": "bring A and B together",
"keyword": "bring-a-and-b-together",
"wordform": "phrasal verb"
},
{
"text": "sandwich A and B together",
"keyword": "sandwich-a-and-b-together",
"wordform": "phrasal verb"
}
]
},
{
"Idioms": [
{
"text": "not a…",
"keyword": "not#not__137"
},
{
"text": "…a pop",
"keyword": "pop_1#pop_1__200"
},
{
"text": "a treat",
"keyword": "treat_2#treat_2__145"
},
{
"text": "be a go",
"keyword": "go_2#go_2__137"
},
{
"text": "to a man",
"keyword": "last1_1#last1_1__323"
},
{
"text": "in a row",
"keyword": "row1_1#row1_1__135"
},
{
"text": "in a way",
"keyword": "way_1#way_1__1455"
},
{
"text": "a bit of a…",
"keyword": "bit#bit__392"
},
{
"text": "a big ask",
"keyword": "ask_2#ask_2__18"
},
{
"text": "in a bind",
"keyword": "bind_2#bind_2__29"
},
{
"text": "a bit much",
"keyword": "bit#bit__373"
},
{
"text": "not a bit",
"keyword": "bit#bit__520"
},
{
"text": "do a bunk",
"keyword": "bunk_1#bunk_1__50"
},
{
"text": "cop a plea",
"keyword": "cop_2#cop_2__100"
},
{
"text": "have a cow",
"keyword": "cow_1#cow_1__82"
},
{
"text": "cut a dash",
"keyword": "dash_1#dash_1__156"
},
{
"text": "five a day",
"keyword": "day#day__500"
},
{
"text": "in a daze",
"keyword": "daze#daze__23"
},
{
"text": "be a devil",
"keyword": "devil#devil__99"
},
{
"text": "a good egg",
"keyword": "egg_1#egg_1__227"
}
]
}
]
}
Em muốn chuyển vào sql chỉ thành 2 trường là keyword và trường còn lại là phần sau dưới dạng string? Cho em hỏi làm cách nào ạ?
83% thành viên diễn đàn không hỏi bài tập, còn bạn thì sao?