What is the correct syntax for including SQL values AND rowsAsArray option in a query?

[millerbryan]

I've looked at all the examples in the docs which use rowsAsArray and it isn't clear how to specify it in a query (rather than in the connection) when passing in SQL values. Is this possible to pass both?

// simplified code
const sql = "select county_name from static_web_data.state_counties where state_name = ?";
const state = "TX"

        try {
          const [rows, fields] = await pool.query({sql, [state], rowsAsArray: true});
          if (rows) {
            return rows;
          }
        } catch (err) {
          console.log(err);
        }

[wellwelwel]

Hi, @millerbryan 🙋🏻‍♂️

You can set it in both connection and query levels:

node-mysql2/website/docs/index.mdx

Lines 452 to 457 in d02aa7c

	const conn = await mysql.createConnection({
	host: 'localhost',
	database: 'test',
	user: 'root',
	rowsAsArray: true,
	});

node-mysql2/website/docs/index.mdx

Lines 481 to 491 in d02aa7c

	try {
	const [results, fields] = await conn.query({
	sql: 'SELECT 1 AS `foo`, 2 AS `foo`',
	rowsAsArray: true,
	});
	console.log(results); // in this query, results will be an array of arrays rather than an array of objects
	console.log(fields); // fields are unchanged
	} catch (err) {
	console.log(err);
	}

You can see the docs#array-results section for more details.

[millerbryan]

Thank you @wellwelwel - I saw those examples in the docs.

However, my question is how to set rowsAsArray in the query when I am also passing in SQL values to the query?

Please see my code snippet in the OP.

Is there a keyword for SQL values like this for SQL values?

try { 
   const [results, fields] = await conn.query({ 
     sql: 'SELECT 1 AS `foo`, 2 AS `foo`', 
     values: [state],
     rowsAsArray: true, 
   });