MATLAB Answers

Passing table name as a variable in Mysql query

88 views (last 30 days)
Raj Tailor
Raj Tailor on 30 Mar 2019
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 Comments

Sign in to comment.

Answers (0)

Sign in to answer this question.

Tags


Translated by