Assign two variables to a SQL Query

9 次查看（过去 30 天）
Cristian Martin
Cristian Martin 2022-6-12
评论： Rik 2022-6-15
Hi,
x=TOYOTA;
Y=9981;
conn = database('baza_date','','');
sqlquery = ['UPDATE prices.prices SET Product =',num2str(x), 'WHERE Crt = ', num2str(y)];
data = fetch(conn,sqlquery);
exec(conn,sqlquery);
close(conn);
Error:
Error using database/fetch (line 40)
[MySQL][ODBC 8.0(a) Driver][mysqld-8.0.29]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 'Crt = 9981' at line 1
Error in bdmodify>pushbutton12_Callback (line 509)
data = fetch(conn,sqlquery);
Error in gui_mainfcn (line 95)
feval(varargin{:});
Error in bdmodify (line 42)
gui_mainfcn(gui_State, varargin{:});
If I use a single variable for query it worked if I use both i recieve this error, i guess i didn't write the code ok, do you know?

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

采纳的回答

Rik
Rik 2022-6-13
I suspect you're missing a space before 'WHERE'. I can recommend using sprintf to avoid such errors.

更多回答（0 个）

类别

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

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by