execute(conn,sqlquery)
executes an SQL query that contains a non-SELECT SQL statement by using
the SQLite database connection with the MATLAB® interface to SQLite.
Using an SQLite database connection and the MATLAB® interface to SQLite, create and execute a non-SELECT SQL statement that creates a temporary view in the database and imports its contents.
Create an SQLite database connection to the SQLite database file tutorial.db.
dbfile = "tutorial.db";
conn = sqlite(dbfile);
Create an SQL statement that creates a temporary view named PRODUCTNAMES. The view selects all product names using the productDescription column of the productTable database table. Execute the CREATE SQL statement.
SQLite database connection, specified as an sqlite object created using the sqlite
function.
sqlquery — SQL statement character vector | string scalar
SQL statement, specified as a character vector or string scalar. The SQL statement
can be any valid non-SELECT SQL statement. For information about the
SQL query language, see the SQL
Tutorial.
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.