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

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). Is this possible?

// 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);
        }

@millerbryan

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.

Navigation Menu

Repository navigation

What is the correct syntax for including SQL values and rowsAsArray option in a query? #3094

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

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

	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);
	}

What is the correct syntax for including SQL values and rowsAsArray option in a query? #3094

Description

Activity

wellwelwel commented on Oct 3, 2024

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions