Passing table name as a variable in Mysql query
15 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hello Experts,
I am trying to pass table name as a variable in mysql query, does anybody knows that is it possible or not?
PS:If I writes table name insead of variable, it works fine.
%I want something like this
datasource='mysql database name';
conn=database(datasource,'',''); %establishing connection to database
tablename='current_records'; %name of mysql table
sqlquery = ['SELECT id FROM ''' tablename ''''];
result = select(conn,sqlquery);
%This one works fine
datasource='mysql database name';
conn=database(datasource,'',''); %establishing connection to database
sqlquery = ['SELECT id FROM current_records'];
result = select(conn,sqlquery);
0 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!