Mysql and matlab

From Knowledge Discovery

If you have access to mysql and the matlab database toolbox here is how you can query from matlab:

• you will need to have the mysql-connector.jar in your matlab classpath.
• you need to run the matlab's jvm, you can't just use matlab command line.
• run 'confds' to configure your datasource.
  • create a new resource.
  • your driver is : com.mysql.jdbc.Driver
  • the url: jdbc:mysql://mysqlhostname.domain:3306:/dbname
• now you can run queries using the 'querybuilder' tool.