Connect to an SQLite database and verify the database connection. Then, import data from the database into MATLAB®. Determine the highest unit cost among the retrieved products in the table. Close the database connection.
Create the SQLite connection conn to the existing SQLite database file tutorial.db. The database file contains the table productTable. The SQLite connection is an sqlite object.
dbfile = "tutorial.db";
conn = sqlite(dbfile);
Determine if the database connection is open. The isopen function returns the numeric scalar 1, which means the database connection is open.
i = isopen(conn)
i = logical
1
Select all the data from productTable and sort it by the product number. data is a table containing the imported data that results from executing the SQL SELECT statement.
sqlquery = "SELECT * FROM productTable ORDER BY productNumber";
data = fetch(conn,sqlquery);
Determine if the database connection is closed. The isopen function returns the numeric scalar 0, which means the database connection is closed. If the database connection is invalid, the isopen function returns the same result.
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.