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.
The MySQL native interface is supported on the Windows® and macOS platforms only.
connection | MySQL native interface database connection |
SQLConnectionOptions | Define MySQL native interface database connection options |
MySQL Native Interface for Windows
Configure a MySQL native interface data source for a MySQL database for Windows.
MySQL Native Interface for macOS
Configure a MySQL native interface data source for a MySQL database for macOS.
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.
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.
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 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.