01@mysql_course_labview+mysql Program Development

Labview+mysqlProgram Development

in the era of big data,LabVIEWprogram Development How can be less a powerful tool of the database, however, most of theLabVIEWengineers know less about database concepts, so this course focuses on how to leverageMySQL, to make their own program up a notch.

first of all, if you want to design a complex large-scale program, the necessary database support, throughout the numerous databases, MySQL with its free and easy to operate, support Internet and LAN access, and many other features, became the preferred database design. This section focuses on database installation issues and database operations.

First step: DownloadMySQLenvironment, Baidu searchMySQL, in the official website we go to the downloader driver, noteLabVIEWThey're usually +connection to the database is also +bit database, so +bit system is easier to install, -bit system needs to be installed when setting up database installation +bit driver (specifically not repeat, can Baidu).

Step two, install MySQL , you will encounter the problem of entering the password, this password needs to be remembered, because after the installation, you need to use this password to log on to the database. If the installation is successful, MySQL ODBC x.x ANSI can be found in the Control Panel-"Administrative Tools-ODBC data Source Manager -" Driver Driver, if not, the driver is not successfully installed.

After the installation is complete, there are a few things in our new software

Open Mysqlworkbench , click the plus sign to create a connection

Configure your account password (Setup at the time of installation) to log into your database

After entering the database, you can click Create database operation to create a database

ClickApply, you can ejectSQLStatement window, this window is very convenient for us to learn the operation of the database statement, as long as the operation will have a statement display, which is why beginners recommendedMySQLthe reason.

With your own database, you can find the new library in the list of databases in the lower-left corner

At this point, no tables are created in the library, and we right-click on a new table on the database (or create a new table with the icon above it)Applyat the same time, note the Learning Popup dialog boxSQLstatement to learn how to use theSQLstatement to dynamically create a table.

You need to refresh the database after the app to display the newly created table

If you have a hint on the table, click on the Small table icon to find out the contents of this table.

In this way, we get the data we need, and we have the corresponding query statements to help understand it.

of course, SQL Grammar is not the only such a few, if necessary, Baidu can search for some related statements, here you can see the following URLs, learning the relevant sentences (test time, choose the appropriate course)

MySQL SQL Statement Daquan (Web page)

Http://www.cnblogs.com/yunf/archive/2011/04/12/2013448.html

MySQL database (VIDEO)

http://study.163.com/course/courseMain.htm?courseId=247003

at this point, we have basically learned the construction of the database environment, the following will explain how to use LabVIEW Connect your database environment to enrich your program's functionality.

From for notes (Wiz)

[email protected]_course_labview+mysql program Development