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