Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData types and operations

JSON data type

Adding a JSON array

Report a typo

The Customers table is defined as:

CREATE TABLE Customers (name JSON);

How can you add a JSON array ['Matthew', 'Merryl'] to this table? Select all the possible ways.

Select one or more options from the list

INSERT INTO Customers VALUES ('["Matthew", "Merryl"]');

INSERT INTO Customers VALUES (ADD_JSON('Matthew', 'Merryl'));

INSERT INTO Customers VALUES (ADD_ARRAY('Matthew', 'Merryl'));

INSERT INTO Customers VALUES (JSON_ARRAY('Matthew', 'Merryl'));

___

Create a free account to access the full topic