how to write a sql query with multiple variables

5 次查看（过去 30 天）
Kallam Haranadha Reddy
评论： Stephen23 2016-8-2
sir, i want to write a SQLquery in which in the where clause i use two variables on two fields.
i tried the following, but getting error messages.
let
x=1; % Variable1
y=4; % Variable2.
curs=exec(conn,['select all from _tablename_ where field1=',num2str(x),and 'field2=',num2str(y)]);
curs=fetch(curs);
I am getting error message.
please guide me.
  1 个评论
Stephen23
Stephen23 2016-8-2
@Mechanical Engineering: please give us the complete error message. This means all of the red text.

请先登录，再进行评论。

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

回答（0 个）

类别

在 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