matlab mysql建系统_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