Getting Error while assigning variable to MySQL database

2 次查看（过去 30 天）

Sudharsan K.R 2019-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/453145-getting-error-while-assigning-variable-to-mysql-database

编辑： Walter Roberson 2019-3-28

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