About the MySQL database interface
Previous Top Next


About the MySQL database interface

graphic

You have seen above that the SA+ contains mechanisms of transferring data to Excel and to Matlab, and we mentioned that the data 'source' for these mechanisms is a database system called MySQL. MySQL is an open-code application, that can be used freely for non-commercial purposes (in fact, MySQL is a success story: in contrast to companies like Microsoft, they make their profits by opening, rather then protecting their code). MySQL provides a foundation of tables, queries and data manipulation methods. You can find the documentation and user manual in 'c:\mysql\docs', but in addition to this, we provide a 'mySQL in a nutshell' summary, with some useful commands in Appendix I.

graphicThe MySQL control center will allow you to observe, copy and query your tables. SA+ does not create any new database but saves all the tables in the default 'mysql' database. To view a table, open the MySQL control center and browse the databases to obtain this view:
  


graphic

Then right-click the table and choose 'return limit'.
You should then select a limit such as 0-1000 and observe the (first 1000) data in the table.

Alternatively, you can select specific data from the table by clicking on a table, and then clicking the SQL button. Here is an example:

For more details about how to design SQL commands, see Appendix I and the MySQL user manual at c:\mySQL\docs.
  

Created using Helpmatic Pro HTML