execute SQL statement
Execute( connection, sql )
database connection obtained using the Open command
string; SQL statement
The Execute command executes an SQL statement using the provided database connection. On success NULL is returned.
This command is intended to be used with SQL statements that do not return any output, such as CREATE TABLE or INSERT.
Use a semicolon (;) to separate statements.
Create in memory database
db ≔ Open⁡:memory::
Create table test with on column val1
Execute⁡db,CREATE TABLE test (val1)
The Database[SQLite][Execute] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
Download Help Document
What kind of issue would you like to report? (Optional)