Getting Error while assigning variable to MySQL database
2 views (last 30 days)
Show older comments
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 Comments
Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!