Perform a Mysql command from Scilab (Unix/Ubuntu).
[M] = NL_F_Mysql2Scilab(D,T,U,passwd,q)
Database.
Table.
Username.
Password.
Query.
Matrix.
NL_F_Mysql2Scilab performs the Mysql query Q on the Table T of the Database D. The result is stored inside the matrix M. It is assumed that the user environment is Linux (e.g. Ubuntu) and that Perl and Mysql are already installed. The script "/NARVAL/demos/PCH2010/Mysql2Scilab.pl" enables the data extraction. The user can also install PhPMyAdmin for an easier management ("sudo apt-get install phpmyadmin"). In the following example, we assume that we have a database "PCH2010" composed by 30 columns ("LOOPID","VEHICULETYPE","DATE","DIRECTION","DAY","N1","N2","N3","N4","N5","N6","N7","N8","N9","N10","N11","N12","N13","N14","N15","N16","N17","N18","N19","N20","N21","N22","N23","SUM","AVG") coming from a traffic monitoring architecture based on magnetic loop counters. A part of this database (50 entries) can be found in /NARVAL/demos/PCH2010.