MySQL Native Interface

Interact with a MySQL^® database using the MySQL native interface

Create a data source and connect to a MySQL database. Explore data and import data from the database into MATLAB^®. Export data from MATLAB into the database. Explore and import data using the Database Explorer app or the command line.

Objects

`connection`	MySQL native interface database connection (Since R2020b)
`SQLConnectionOptions`	Define MySQL native interface database connection options (Since R2020b)

Functions

expand all

MySQL Native Interface Configuration

`databaseConnectionOptions`	Create database connection options (Since R2020b)
`rmoptions`	Remove MySQL native interface connection options (Since R2020b)
`saveAsDataSource`	Save MySQL native interface data source (Since R2020b)
`setoptions`	Set MySQL native interface connection options (Since R2020b)
`reset`	Reset MySQL native interface connection options to defaults (Since R2020b)
`testConnection`	Test MySQL native interface database connection (Since R2020b)

MySQL Native Interface Connection

`mysql`	Create MySQL native interface database connection (Since R2020b)
`close`	Close MySQL native interface database connection (Since R2020b)
`isopen`	Determine if MySQL native interface database connection is open (Since R2020b)
`sqlfind`	Find information about all table types in MySQL database (Since R2020b)

Import Data into MATLAB

`fetch`	Import results of SQL statement in MySQL database into MATLAB (Since R2020b)
`sqlread`	Import data into MATLAB from MySQL database table (Since R2020b)
`sqlinnerjoin`	Inner join between two MySQL database tables (Since R2020b)
`sqlouterjoin`	Outer join between two MySQL database tables (Since R2020b)
`executeSQLScript`	Execute SQL script on MySQL database (Since R2020b)

Customize Options for Data Import from Database

`databaseImportOptions`	Define import options for database data
`getoptions`	Retrieve import options for database data
`preview`	Preview eight rows from database using import options
`setoptions`	Customize import options for database data
`reset`	Reset to default import options for database data

Import Large Data into MATLAB

`databaseDatastore`	Datastore for data in database
`hasdata`	Determine if data in `DatabaseDatastore` is available to read
`preview`	Return subset of data from `DatabaseDatastore`
`read`	Read data in `DatabaseDatastore`
`readall`	Read all data in `DatabaseDatastore`
`reset`	Reset `DatabaseDatastore` to initial state
`splitsqlquery`	Split SQL query using paging
`createConnectionForPool`	Initialize parallel pool using database connection

Export Data from MATLAB

sqlwrite Insert MATLAB data into MySQL database table (Since R2020b)

Database Operations

`execute`	Execute SQL statement using MySQL native interface database connection (Since R2020b)
`commit`	Make changes to MySQL database permanent (Since R2020b)
`rollback`	Undo changes to MySQL database (Since R2020b)
`sqlupdate`	Update rows in MySQL database table (Since R2023a)

Topics

Configure MySQL Native Interface

Configure MySQL Native Interface Data Source
Configure a MySQL native interface data source for a MySQL database for Windows^® and macOS.

Import Data into MATLAB

Import Data from MySQL Database Table
Import data from one table by using various functions.
Customize Options for Importing Data from Database into MATLAB Using MySQL Native Interface
Customize import options for multiple variables when importing data from a MySQL database.
Import Large Data Using DatabaseDatastore Object and MySQL Native Interface
Create a DatabaseDatastore object for accessing collections of data stored in a MySQL database.

Export Data from MATLAB

Insert Data into Database Table Using MySQL Native Interface
Perform calculations on data and insert the results into a MySQL database using the sqlwrite function.

Execute Database Operations

Create Table and Add Column Using MySQL Native Interface
Manage MySQL database structures using the CREATE and ALTER SQL statements.
Delete Data from Database Using MySQL Native Interface
Delete data from a MySQL database using MATLAB.
Roll Back Data in Database Using MySQL Native Interface
Execute the ROLLBACK SQL statement to reverse changes in a MySQL database by using the execute function.

Deploy Standalone Database Application

Deploy MySQL Native Interface Database Application with MATLAB Compiler
Write a MATLAB script that connects to a MySQL database and deploy the script as a standalone database application to other machines.