Database Toolbox™ enables you to create SQL queries by building them visually using the Database Explorer app or by writing them using SQL. To import data into the MATLAB workspace, run a SQL query and import the data.
|Database Explorer||Configure, explore, and import database data|
|Execute SQL SELECT statement and import data into MATLAB|
|Execute SQL statement and open cursor|
|Import data into MATLAB workspace from database cursor or from execution of SQL statement|
|Import data from multiple result sets|
|Run SQL script on database|
|Call stored procedure with and without input and output arguments|
|Retrieve attributes of columns in fetched data set|
|Retrieve number of columns in fetched data set|
|Retrieve names of columns in fetched data set|
|(To be removed) Retrieve object properties|
|Get time specified for SQL queries to succeed|
|Return number of rows in fetched data set|
|(To be removed) Set properties for database or cursor object|
|Return field size of column in fetched data set|
Decide the best way to import data from your database into MATLAB.
Save memory when importing data using functions and limiting the number of rows.
Write simple and more complex SQL queries for importing data into MATLAB.
Learn about scrollable cursors and how they behave with different drivers.
Define stored procedures in a database and call them
Explore the structure and attributes of imported data
Analyze data without access to a database or driver by using the MATLAB interface to SQLite.