Ad Widget

Collapse

MySQL: can't "select from databasename.tablename" via custom query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Humulus
    Junior Member
    • Mar 2025
    • 3

    #1

    MySQL: can't "select from databasename.tablename" via custom query

    I'm trying to use custom queries with MySQL.
    A simple working statement is:
    Code:
     SELECT * FROM databasename.tablename
    But when I try to make databasename a parameter:
    Code:
     SELECT * FROM ?.tablename
    it doesn't work, because the parameter is recognized as text and automatically padded with single quotes (') like
    Code:
     SELECT * FROM 'databasename'.tablename
    Is it possible to change the plugin, so it takes the parameters literally?

Working...