Sqlite Toolkit - @octave_sqlite/execute

: execute (db, sqlquery)

Execute a SQL statement on a sqlite database

Execute non select SQL query sqlquery on a sqlite database.

Inputs

db

Previously created octave_sqlite object

sqlquery

A valid non selecting SQL query string

Inputs

None

Examples

Create a database table and insert a row

 
 # create sql connection
 db = sqlite("mytest.db", "create");
 # create table and then insert a row
 execute(db, 'CREATE TABLE Test (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT)');
 execute(db, 'INSERT INTO Test (Name) VALUES ("Line1")');
 
 

See also: sqlite, fetch.