X Plugin city Table Description Insert a Record Select a Record Related Information 20.5 X Plugin 20.5.1 Checking X Plugin Installation 3885 This section explains how to use, configure and monitor X Plugin. You can issue a query with a search condition that evaluates document values in the expression. 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. The city table has five columns (or fields). mysql-py>  db.city.insert().values( None, "San Francisco", "USA", "California", ’{"Population":830000}’) +---------------+------------+-------+-------+---------+------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+-------+-------+---------+------------------+ | ID | int(11) | NO | PRI | null | auto_increment | | Name | char(35) | NO | | | | | CountryCode | char(3) | NO | | | | | District | char(20) | NO | | | | | Info | json | YES | | null | | +---------------+------------+-------+-------+---------+------------------+ +------+----------------+-------------+----------------+-----------------------------+ | ID | Name | CountryCode | District | Info | +------+----------------+-------------+----------------+-----------------------------+ | 3793 | New York | USA | New York | {"Population": 8008278} | | 3794 | Los Angeles | USA | California | {"Population": 3694820} | | 3795 | Chicago | USA | Illinois | {"Population": 2896016} | | 3796 | Houston | USA | Texas | {"Population": 1953631} | | 3797 | Philadelphia | USA | Pennsylvania | {"Population": 1517550} | | 3798 | Phoenix | USA | Arizona | {"Population": 1321045} | | 3799 | San Diego | USA | California | {"Population": 1223400} | | 3800 | Dallas | USA | Texas | {"Population": 1188580} | | 3801 | San Antonio | USA | Texas | {"Population": 1144646} | +------+----------------+-------------+----------------+-----------------------------+ 9 rows in set (0.01 sec) mysql-py>  db.city.select(["ID", "Name", "CountryCode", "District", "Info"]).where( "CountryCode = :country and Info->’$.Population’ > 1000000").bind( ’country’, ’USA’) •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. 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.