> > >

MySQL MCQs

You are importing data as JSON into a new table. You run CREATE TABLE json_data ( city JSON ); and insert rows into this table. What is the correct syntax to see the list of cities?

SELECT city FROM json_data;

SELECT city->>'$.name' city FROM json_data;

SELECT city.name city FROM json_data;

SELECT city->'$.name' city FROM json_data;

Answer

Correct Answer: SELECT city->>'$.name' city FROM json_data;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it