采用odbc连接数据库时遇到的问题,jdbc没问题
colnames = {'time','course','depth','distance'};
data = table(time',thapsz',Ps(2,:)',Ps(1,:)', ...
'VariableNames',colnames);
tablename = 'paths';
datainsert(conn,tablename,colnames,data);
修改成逐行插入
insertString = sprintf('INSERT INTO paths(time,course,depth,distance) VALUES(%d,%d,%d,%d)', timei(i),thapszi(i),Ps2(i),Ps1(i));
exec(conn,insertString);