From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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