Accessing .sql database file

Question

Greg 2012-3-21

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/32959-accessing-sql-database-file

So first of all, I have almost zero database experience. I've mainly used MATLAB for modeling purposes in the past, but now I need to do some calculations with some data stored in an SQL database.

I've been provided with a .sql file, containing the database. This database contains several tables which I'd like to access and run queries on in order to perform calculations.

I've downloaded the Database Toolbox package, and have been trying to make a connection using the 'database' command, but there seems to be an issue concerning the JDBC drivers.

My question is: what do I need to do, what do I need to install and configure in order to be able to perform SQL queries on the Database.sql file?

As I said, I've never worked with databases before so I have minimal knowledge.

Many thanks in advance,

Greg

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Aldin 2012-3-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/32959-accessing-sql-database-file#answer_41550

Look here for connection:

http://www.mathworks.com/matlabcentral/answers/32618-connecting-to-mysql-using-jdbc

and here for SQL Query: type:

doc database

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Greg 2012-3-22

thanks, I'd already checked that out, but what I don't get is: is the JDBC driver something that needs to be downloaded and installed separately, or does it come with the database toolbox?

I'm using Mac OS X 10.6 btw.

请先登录，再进行评论。