K
Join ServerKysely
help
Cross database joins in MySQL
Hi all,
Is it possible to do joins across databases within the same MySQL instance?
i.e
I've generated the typings for both databases, but not sure if there's a way to leverage them?
Is it possible to do joins across databases within the same MySQL instance?
i.e
SELECT * FROM db1.table1 INNER JOIN db2.table2 ON db1.table1.id = db2.table2.id
I've generated the typings for both databases, but not sure if there's a way to leverage them?
Hey ๐๐ป
I thought I pointed that schemas might work here in another thread.. ๐
Glad you found the answer!
I thought I pointed that schemas might work here in another thread.. ๐
Glad you found the answer!
i may have potentially overlooked that, because i wasnt aware of what 'schemas' in pg were ๐
. ended up ctrl f'ing through this server for 'multiple database' and found the same thing. hopefully this thread also helps with the discoverability for future mysql people