%# JDBC connector path
javaaddpath('C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.28-bin.jar') %# connection parameteres
host = 'localhost'; %MySQL hostname
user = 'root'; %MySQL username
password = 'root';%MySQL password
dbName = 'liptrackingdb'; %MySQL database name
%# JDBC parameters
jdbcString = sprintf('jdbc:mysql://%s/%s', host, dbName); jdbcDriver = 'com.mysql.jdbc.Driver'; conn = database(dbName, user , password, jdbcDriver, jdbcString); if isconnection(conn) qry = sprintf('INSERT INTO lipcountor(top,bottom,left,right) VALUES(%.3f,%.3f,%.3f,%.3f);',distAa,distBa,distCa,distDa); display(qry); fetch(exec(conn, qry)); else display('MySql Connection Error');end
the matlab console also display the value correctly
qry =INSERT INTO lipcountor(top,bottom,left,right) VALUES(25.000,24.000,30.000,36.000);
but the value is not inserted in the database there is not even error.help
I have also tried
fastinsert(conn, 'productTable', {'top','bottom','left','right'}, {distAa,distBa,distCa,distDa});
were error arries
Error using database/fastinsert (line 155)You have an error in your SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntax to use near 'right from productTable LIMIT 0' at line1 Error in GUI>pbfacedetection_Callback (line 673) fastinsert(conn, 'productTable', {'top','bottom','left','right'}, {distAa,distBa,distCa,distDa});
Best Answer