Mysql Toolkit - connection.execute

execute (conn, query)

Perform SQL query query, that does not return result

Inputs

db

Previously created database connection object

sqlquery

A valid non-selecting SQL query string

Outputs

None

Examples

Create a database table and insert a row

 
 # create sql connection
 db =  mysql("MySQLNative", "root", "matlab");
 # create table and then insert a row
 execute(db, 'CREATE TABLE Test (Id INTEGER PRIMARY KEY AUTO INCREMENT, Name TEXT)');
 execute(db, 'INSERT INTO Test (Name) VALUES ("Line1")');
 
 

See also: mysql, fetch.