how to write a sql query with multiple variables

2 次查看（过去 30 天）

显示更早的评论

Kallam Haranadha Reddy 2016-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/298104-how-to-write-a-sql-query-with-multiple-variables

评论： Stephen23 2016-8-2

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2016-8-2

@Mechanical Engineering: please give us the complete error message. This means all of the red text.

请先登录，再进行评论。

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

回答（0 个）

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

类别

MATLAB Language Fundamentals Data Types Tables

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

Community Treasure Hunt

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

Start Hunting!

Translated by