Passing table name as a variable in Mysql query

19 次查看（过去 30 天）
Raj Tailor
Raj Tailor 2019-3-30
回答： Piyush Kumar 2024-9-30
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);

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-9-30
Ran in:
@Raj Tailor,
The issue is with the SQL query string. You should not use single quotes around the table name. Single quotes are used for string literals in SQL, not for identifiers like table names.
tablename='current_records'; %name of mysql table
sqlquery = ['SELECT id FROM ''' tablename ''''];
disp(sqlquery)
SELECT id FROM 'current_records'
Instead, you should use sprintf or proper string concatenation to correctly format the SQL query.
tablename = 'current_records'; % Name of the MySQL table
sqlquery = sprintf('SELECT id FROM %s', tablename);
disp(sqlquery)
SELECT id FROM current_records
tablename = 'current_records'; % Name of the MySQL table
sqlquery = ['SELECT id FROM ', tablename];
disp(sqlquery)
SELECT id FROM current_records

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by