Getting Error while assigning variable to MySQL database
2 次查看(过去 30 天)
显示 更早的评论
I am trying to execute the below query and getting the below error. Kindly help me out
datasource = 'MY SQL Server Auth';
conn = database('MYDB','user','pwd');
var= "number";
selectquery = ['Select * from TABLE2 where Sensor_value = ' var];
data = fetch(conn,selectquery)
close(conn)
Error:-
Error using database.odbc.connection/fetch (line 39)
ODBC Driver Error: [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.25-0ubuntu0.18.04.2]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&' at line 1
0 个评论
回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!