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?

🎲 Try a Random Question  |  Total Questions in Quiz: 98  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
MySQL Test — practice the complete quiz, review flashcards, or try a random question.

MySQL MCQs For LinkedIn Skill Assessments.


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?