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
`SQLConnectionOptions`	Define MySQL native interface database connection options

Functions

expand all

MySQL Native Interface Configuration

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

MySQL Native Interface Connection

`mysql`	Create MySQL native interface database connection
`close`	Close database connection
`isopen`	Determine if database connection is open
`sqlfind`	Retrieve metadata about database objects

Import Data into MATLAB

`fetch`	Import data from execution of SQL statement
`sqlread`	Import table data from database
`sqlinnerjoin`	Perform inner join on two database tables
`sqlouterjoin`	Perform outer join on two database tables
`executeSQLScript`	Execute SQL script on MySQL database

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`	Create 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 database table

Database Operations

`commit`	Make changes to database permanent
`execute`	Execute SQL statement on database
`rollback`	Revert changes made to database
`sqlupdate`	Update rows in 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.