code_junkie

How do I enable cross-database joins in mysql?

Nov 12th, 2011
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. INSERT `dbsandbox`.`SomeTable`(Field1, Field2, Field3)
  2. SELECT t.Field1, t.Field2, t.Field3
  3. FROM `dbprod`.`SomeTable` t;
  4.  
  5. SELECT t.Field1, t.Field2, t.Field3
  6. FROM `dbprod`.`SomeTable` t;
Add Comment
Please, Sign In to add comment