mysql+matlab配置

• mysql 中一直出现'>

　　　　单双引号没有配对

 

• mysql 连接matlab

1， 到mysql官网下载 http://dev.mysql.com/downloads/connector/j/
(mysql-connector-java-5.1.37.tar.gz
将mysql-connector-java-5.1.37-bin.jar 放在matlabroot/java/jar/toolbox/

2， 在E:\Program Files\MATLAB\R2011b\toolbox\local目录下，找到classpath.txt
增加一句
$matlabroot/java/jar/toolbox/mysql-connector-java-5.1.37-bin.jar

注意：驱动名字匹配
$matlabroot指安装目录

3，重启matlab

4，测试

conn = database('xw','root','key','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/xw')

aTemp = exec(conn,'select * from gd_train_data limit 5')
aTemp = fetch(aTemp);

curs = aTemp.Data