Getting Error while assigning variable to MySQL database

6 次查看（过去 30 天）
Sudharsan K.R
Sudharsan K.R 2019-3-28
回答： Piyush Kumar 2024-9-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

请先登录，再回答此问题。

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-9-30
Ran in:
@Sudharsan K.R,
The issue is with the way the query string is constructed.
var= "number";
selectquery = ['Select * from TABLE2 where Sensor_value = ' var];
disp(selectquery)
"Select * from TABLE2 where Sensor_value = " "number"
To fix this, ensure that the variable is correctly concatenated into the SQL query string. In MATLAB, you can use "sprintf" -
selectquery = sprintf('SELECT * FROM TABLE2 WHERE Sensor_value = "%s"', var);
disp(selectquery)
SELECT * FROM TABLE2 WHERE Sensor_value = "number"

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by