how to write a sql query with multiple variables
显示 更早的评论
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
2016-8-2
@Mechanical Engineering: please give us the complete error message. This means all of the red text.
回答（0 个）
类别
在 帮助中心 和 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 
