Slide 30
Slide 30 text
Inserting JSON Data
INSERT INTO artists (id, name, founded, albums)
VALUES (
1,
'Anastacia',
1999,
'[
{
"title": "Not That Kind",
"published": 2000,
"tracks": [
{ "trackNumber": 1, "title": "Not That Kind" },
{ "trackNumber": 2, "title": "I''m Outta Love" },
{ "trackNumber": 3, "title": "Cowboys & Kisses" }
]
},
{
"title": "Freak Of Nature",
"published": 2001,
"tracks": [{ "trackNumber": 1, "title": "Paid My Dues"}]
}
]'
);