3. Import the world_x.sql  file to your server. You can either: 

•Start MySQL Shell in SQL mode and import the file by issuing: 

mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql Enter password: **** 

•Set MySQL Shell to SQL mode while it is running and source the schema file by issuing: 

\sql Switching to SQL mode... Commands end with ; \source /tmp/world_x-db/world_x.sql 

Replace /tmp/  with the path to the world_x.sql  file on your system. Enter your password if prompted. A non-root account can be used as long as the account has privileges to create new schemas. 

## The world_x Schema 

The world_x  example schema contains the following JSON collection and relational tables: 

## Related Information 

## 20.3.3 Documents and Collections 

•Collection 

• countryinfo : Information about countries in the world. 

•Tables 

• country : Minimal information about countries of the world. 

• city : Information about some of the cities in those countries. 

• countrylanguage : Languages spoken in each country. 

•MySQL Shell Sessions explains session types. 

When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. 

The examples in this section use the countryinfo  collection in the world_x  schema. For instructions on setting up the world_x  schema, see Section 20.3.2, “Download and Import world_x Database” . 

## Documents 

In MySQL, documents are represented as JSON objects. Internally, they are stored in an efficient binary format that enables fast lookups and updates. 

•Simple document format for JavaScript: 

{field1: "value", field2 : 10, "field 3": null} 

An array of documents consists of a set of documents separated by commas and enclosed within [  and ] characters. 

•Simple array of documents for JavaScript: 

