About the MySQL database interface
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.
The 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:
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