MySQL not outputting actual data

[JakeS]

I am running the MySQL but it just outputs “success” and not the actual result of the query. What am I doing wrong?

Please see image below

Thanks

[JakeS]

When i dont include a “variable” then it works fine, see below

[EmeraldHerald]

Hi @JakeS Welcome to the community

Do you have an example workflow you could share that has test data that wouldn’t require any outside credentials for testing? Essentially we’d need some test data that replicates this case. If you could provide test data in JSON format, that works too!

Can you also fill out the following:

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[JakeS]

@EmeraldHerald I fixed the issue, basically the query was returning 0 results but it wasn’t clear in the UI as it just said Success. Would be good to see how many results are returned, that would have helped avoid confusion on what the message meant