Assign two variables to a SQL Query

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?

Answer 1

[Rik]

I suspect you're missing a space before 'WHERE'. I can recommend using sprintf to avoid such errors.

[Cristian Martin]

Indeed that was it, thanks!

[Rik]

You're welcome