Assign two variables to a SQL Query

2 views (last 30 days)
Cristian Martin
Cristian Martin on 12 Jun 2022
Commented: Rik on 15 Jun 2022
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?

Accepted Answer

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

More Answers (0)

Products


Release

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by