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

12 visualizzazioni (ultimi 30 giorni)
ashutosh chandra bhensle
ashutosh chandra bhensle il 22 Mag 2014
Commentato: ashutosh chandra bhensle il 23 Mag 2014
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!!

Accedi per rispondere a questa domanda.

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su Database Toolbox in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by