node.js - mysql2 nodejs pass table name as variable / right syntax to use near '??'

Question

Hi I am trying to run a query but getting the following error: Nodej Mysql2

query

tableName = "some_table"
id = "some_id";

const readForwardedMessageDetails = pool.execute('SELECT * FROM ?? WHERE `id` = ? LIMIT 1',
        [tableName, id],
        function(err, row) {
            if (err) {
                console.log(err)
                return
            } else {
            
            }
            
            code: 'ER_PARSE_ERROR',
                errno: 1064,
                sqlState: '42000',
                sqlMessage: "You have an error in your SQL syntax; check the manual 
            that corresponds to your MariaDB server version
            for the right syntax to use
            near '?? WHERE `id` = ? LIMIT 1'
            at line 1 ",
            sql: 'SELECT * FROM ?? WHERE `id` = ? LIMIT 1'

Was trying from here : Nodejs-Mysql Query table name as a variable

Also use of ?? double question marks for tablename is given here : https://github.com/mysqljs/mysql#preparing-queries

MySql2 suggests it is mostly compatible with mysql so tried the answers above. https://github.com/sidorares/node-mysql2#history-and-why-mysql2 : MySQL2 is mostly API compatible with mysqljs and supports majority of features. MySQL2 also offers these additional features (hence the inference)

Answer 1

I had raised the issue with MySql2 since they have mentioned on their website to report any incompatibilities with MySql https://www.npmjs.com/package/mysql2#api-and-configuration stating If you find any incompatibility with Node MySQL, Please report via Issue tracker. We will fix reported incompatibility on priority basis.

Their response is https://github.com/sidorares/node-mysql2/issues/1435

while similar to the .query() .execute() syntax is different and only supports what valid input for PREPARE is ( see https://dev.mysql.com/doc/refman/8.0/en/prepare.html ). You can get your ?? interpolated on the client side in a separate step or just switch to non-prepares statements call with .query()

Passing table name in query is just fine depending on your program requirement especially reusable components can be made where table names are switched/column names are switched. For eg. if you have comments table for different entities and maintaining different tables for these (imagine how one big comment table would perform for the whole website)