What is the correct syntax for including SQL values AND rowsAsArray option in a query? #3095
Replies: 2 comments
-
Hi, @millerbryan 🙋🏻♂️ You can set it in both connection and query levels: node-mysql2/website/docs/index.mdx Lines 452 to 457 in d02aa7c node-mysql2/website/docs/index.mdx Lines 481 to 491 in d02aa7c You can see the docs#array-results section for more details. |
Beta Was this translation helpful? Give feedback.
-
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?
|
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
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?Beta Was this translation helpful? Give feedback.
All reactions