#community-help

Achieving MySQL tables join in Typesense

TLDR Shabber enquired about simulating MySQL table joins in Typesense. Kishore Nallan responded that Typesense doesn't support joins and suggested storing data as a single document.

Powered by Struct AI

1

Jun 28, 2023 (5 months ago)
Shabber
Photo of md5-5a2ce5f6a332437f74a5fd2f2c98052e
Shabber
10:18 AM
HI ,
in mysql i have two tables from which old autocomplete works by joining two tables.
how can we achieve this in typesense .
there might be cases all time table values get updated
any suggestion for this please ?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
10:21 AM
We don't support join at the moment. So you have to store them as a single document.
Shabber
Photo of md5-5a2ce5f6a332437f74a5fd2f2c98052e
Shabber
10:22 AM
Ok Thank you

1