Custom Mysql Query

The idea is:

To have the ability to create a custom mysql query within a mysql node.

My use case:

I would like to be able to pull data from multiple tables when a order comes in and a new row hits the database.

I think it would be beneficial to add this because:

The benefit of this would be able to join multiple tables, do case statements, and basically open up the entire mysql arsenal to be able to get all of the data you need.

Any resources to support this?

Are you willing to work on this?

Yes.

Perhaps I misunderstand, but the MySQL node already supports free-form queries? See the documentation for more information.

Hey bartv,
Thank you! I’ve only been using n8n for about a week and overlooked that feature. I appreciate your feedback. Now we just need a trigger that triggers on a new row! Thanks again for your help.

1 Like