2

I am using NodeJs. connector X-devAPI for writing queries. I need to use a join query . How do I write query ?

const session = mySqlx.getSession(config); const schema = await session.getSchema('xxxx'); let tableresp = await schema.getTable('tableName'); tableresp = await tableresp .select(['id', 'name', 'Mobile']) .execute(function (row) { console.log(row) });
Improve this question

1 Answer 1

Reset to default
6

At the moment you have to use plain SQL queries.

await session.sql('SELECT id, name, Mobile FROM xxxx.tableName JOIN ...').execute()

Sorry for the late answer. Your question didn't show up in the tags I was watching.

Disclaimer: I'm the lead dev of the MySQL X DevAPI Connector for Node.js

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.