Mysql Toolkit - Functions
The following functions are available:
MYSQL connection
| mysql | Create a MySQL database connection |
| connection.isopen | Return true if mysql connection is open |
| connection.close | close mysql connection |
| connection.sqlfind | Find information about table types in a database. |
Importing Data
| connection.fetch | Perform SQL query QUERY, and return result |
| connection.sqlread | Read data from table TABLENAME |
Exporting Data
| connection.sqlwrite | Insert rows of data into a table. |
Database Operations
| connection.commit | Make permanent changes to the database. |
| connection.execute | Perform SQL query QUERY, that does not return result |
| connection.rollback | Rollback changes to the database. |
| connection.sqlupdate | Update rows of data in database. |
Support Functions
| rowfilter | Create an unconstrained rowfilter object with columns names. |