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

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!!

 采纳的回答

Your syntax is wrong. Try the following:
id = 1; qry = sprintf('Select fname From mydb.myface WHERE id = %d', id);

更多回答(0 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by