Main Content

execute

Execute SQL statement using SQLite database connection

Description

example

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.

Examples

collapse all

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.

sqlquery = strcat("CREATE TEMP VIEW PRODUCTNAMES AS", ...
    " SELECT productDescription FROM productTable");
execute(conn,sqlquery)

Import the product names using the new temporary view and display the first three names.

sqlquery = "SELECT * FROM PRODUCTNAMES";
results = fetch(conn,sqlquery);
head(results,3)
ans=3×1 table
    productDescription
    __________________

     "Victorian Doll" 
     "Train Set"      
     "Engine Kit"     

Close the database connection.

close(conn)

Input Arguments

collapse all

SQLite database connection, specified as an sqlite object created using the sqlite function.

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.

Example: "DROP VIEW PRODUCTNAMES"

Data Types: char | string

Version History

Introduced in R2022a