How to practice this tutorial in MCC or in Matlab
Previous Top Next

How to practice this tutorial in MCC or in Matlab

This tutorial can be practiced in either the MySQL Control Center or in Matlab.

To use the MySQL Control Center (MCC): open MCC (Start -> All programs -> MySQL Control Center).
If this is the first time you open MCC please follow the instructions in section 6c. If the server (root) is not connected, right click on it and choose 'connect'. Once the consol manager shows the databases, select 'sap' so that the tables of 'sap' database are shown at the right panel. Double click on a table to open it and then click the 'sql' button (below the console menu). You can then easily type your query and then click '!' to execute. The results of the query (if there are any) should show up at the lower panel.

To use Matlab: download the files () from the link in () and copy them to ..\Matlab… This free utility will allow you to use MySQL in Matlab using the function 'mysql()'. To start type
mysql('open');

And Matlab should say something like:
Connecting to  host=localhost Uptime: 81473  Threads: 5  Questions: 5529  …

Then type
mysql('use sap');

and Matlab should say “Current database is "sap"” and that's it. You are now ready to type queries.

 
  

Created using Helpmatic Pro HTML