MySQL9 Embeddings - Save a Vector

Questions
1

Hey. I have a mysql9 Database with a Vector field. I want to save a Vector there.

The Vector Value is a string like this [0.009412757, -0.016945556, 0.010508319] and i need to save it with a mysql function STRING_TO_VECTOR( but i see no possibility to add this function outside the value.

Finally it looks like this:

UPDATE for_messagesSETembedding = 'STRING_TO_VECTOR(\'[0.00941275

Any ideas. Thanks already now.

sql: UPDATE for_messages SET embedding = ‘STRING_TO_VECTOR('[0.009412757,-0.016945556,0.010508319…]')’, = ‘’ WHERE timestamp = 1731505390.229889, code: ER_PARSE_ERROR

Information on your n8n setup

  • n8n version: 1.74.1
  • Running n8n via Docker
  • Mac OS
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Solution is to use “execute sql” and to build your own query.

1 Like
4

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