SmartSQLVIEW for MySQL toolkit supports the following features :
SmartSQLVIEW for MySQL toolkit is located in SAPHIR palette
Name | Icon | Help |
---|---|---|
Open database | This VI attempts to establish a connection to a MySQL database engine running on host. This VI must complete successfully before you can execute any other API VI. | |
Execute SQL query | This VI executes an SQL query. | |
Close database | This VI closes a connection to a MySQL database engine previously opened. | |
Create transaction | This VI creates a new transaction. Such transactions usually persist until the next COMMIT or ROLLBACK command. But a transaction wills also ROLLBACK if the database is closed or if an error occurs. | |
Commit transaction | This VI commits all modifications that occurred on the database since the last call of the method BeginTransaction. | |
Rollback transaction | This VI cancels all modifications that occurred on the database since the last call of the method BeginTransaction. | |
Get table information | This VI provides information about each non-temporary tables. | |
Get columns information | This VI provides information about each column of a given table. | |
Ping server | This VI tests the connection and reset the connection inactivity counter in the MySQL server. | |
Get server statistics | This VI returns some MySQL server statistics. |
SmartSQLVIEW for MySQL toolkit is provided with comprehensive examples demonstrating how to access MySQL database. You can find them browsing "NI Example Finder".
SmartSQLVIEW for MySQL is provided with a useful tool allowing to quickly test communication with any MySQL databases. You can find it in Tools >> SAPHIR >> SmartSQLVIEW for MySQL >> MySQL database connection test...
* Please contact us if you are interested in support for other Operating Systems like Linux or Mac OSX