close

Close MySQL native interface database connection

Since R2020b

Syntax

close(conn)

Description

close(conn) closes and invalidates the MySQL^® native interface database connection to free up database and driver resources.

Examples

Connect to MySQL Database Using MySQL Native Interface

Create a MySQL® native interface connection to a MySQL database. Then, import data from the database into MATLAB® and perform simple data analysis. Close the database connection.

This example assumes that you are connecting to a MySQL database using the MariaDB® C Connector driver.

Connect to the database using the data source name, user name, and password.

datasource = "MySQLNative";
username = "root";
password = "matlab";

conn = mysql(datasource,username,password)

conn = 
  connection with properties:

                  DataSource: "MySQLNative"
                    UserName: "root"

  Database Properties:

                  AutoCommit: "on"
                LoginTimeout: 0
      MaxDatabaseConnections: 0

  Catalog and Schema Information:

              DefaultCatalog: "toy_store"
                    Catalogs: ["information_schema", "mysql", "performance_schema" ... and 3 more]
                     Schemas: []

  Database and Driver Information:

         DatabaseProductName: "MySQL"
      DatabaseProductVersion: "8.0.3-rc-log"
                  DriverName: "Mariadb Connector/C"
               DriverVersion: "3.2.5"

The property sections of the connection object are:

• Database Properties — Information about the database configuration

• Catalog and Schema Information — Names of catalogs and schemas in the database

• Database and Driver Information — Names and versions of the database and driver

Import all data from the table inventoryTable into MATLAB using the sqlread function. Display the first three rows of data.

tablename = "inventoryTable";
data = sqlread(conn,tablename);
head(data,3)

    productNumber    Quantity    Price       inventoryDate    
    _____________    ________    _____    ____________________

          1            1700       15      23-Sep-2014 13:38:34
          2            1200        9      09-Jul-2014 02:50:45
          3             356       17      14-May-2014 11:14:28

Determine the highest product quantity from the table.

max(data.Quantity)

ans = 9000

Close the database connection conn.

close(conn)

Input Arguments

conn — MySQL native interface database connection

connection object

MySQL native interface database connection, specified as a connection object.

Version History

Introduced in R2020b