content_image/674309.jpg content_image/674310.jpg
## city Table Description 

The city table has five columns (or fields). 

<img src='content_image/674309.jpg'>

## Insert a Record 

To insert a document into the column of a table, pass to the values()  method a well-formed JSON document in the correct order. In the following example, a document is passed as the final value to be inserted into the Info column. 

## Select a Record 

mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", ’{"Population":830000}’) 

You can issue a query with a search condition that evaluates document values in the expression. 

mysql-py> db.city.select(["ID", "Name", "CountryCode", "District", "Info"]).where( "CountryCode = :country and Info->’$.Population’ > 1000000").bind( ’country’, ’USA’) 

<img src='content_image/674310.jpg'>

## Related Information 

•See Working with Relational Tables and Documents for more information. 

•See Section 11.5, “The JSON Data Type”  for a detailed description of the data type. 

## 20.5 X Plugin 

## 20.5.1 Checking X Plugin Installation 

This section explains how to use, configure and monitor X Plugin. 

X Plugin is enabled by default in MySQL 8, therefore installing or upgrading to MySQL 8 makes the plugin available. You can verify X Plugin is installed on an instance of MySQL server by using the SHOW plugins  statement to view the plugins list. 

