how to write a sql query with multiple variables
2 次查看(过去 30 天)
显示 更早的评论
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 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!