试用软件

how can i use variable instead of constant to get data from mysql database?

4 次查看（过去 30 天）

显示更早的评论

ashutosh chandra bhensle 2014-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/130632-how-can-i-use-variable-instead-of-constant-to-get-data-from-mysql-database

评论： ashutosh chandra bhensle 2014-5-23

采纳的回答： Roger Wohlwend

qry = sprintf('Select fname From mydb.myface WHERE id=1');

working but

id=1; qry = sprintf('Select fname From mydb.myface WHERE id=id'); not working please help me!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Roger Wohlwend 2014-5-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/130632-how-can-i-use-variable-instead-of-constant-to-get-data-from-mysql-database#answer_137824

Your syntax is wrong. Try the following:

id = 1; qry = sprintf('Select fname From mydb.myface WHERE id = %d', id);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

ashutosh chandra bhensle 2014-5-23

thanks...Roger..Its working,,,

请先登录，再进行评论。

更多回答（0 个）

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

类别

Reporting and Database Access Database Toolbox

Computational Finance Database Toolbox

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

标签

Community Treasure Hunt

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

Translated by

试用软件