ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB

Can you please help me with this error. I am trying to query insert SQL.

Hi @daniel.o,
are you using n8n’s MySQL node? Also would you be able to share your workflow here by copy/pasting all your workflows nodes here like this

```
workflow.json
```

It is most likely an unescaped quote - ie the field value itself has a ’ in it.
You will have to replace the quote - something like this
‘{{$node[“MyNodeName”].json[“last_name”].replace(’'‘,“”)}}’
replace ’ with nothing

1 Like

Can you give me a working example?

Thanks it worked!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.