double outer joins in mysql?

2002-02-18 Thread Todd Goldenbaum
hi, I'm wondering if anyone knows if it's possible to do a double-outer join in mysql. by that I mean outer-joining on two tables instead of one (both from the same original table). in other words, whereas a normal outer join might go something like this: select b.date, u.name from billing b

cross-updates with replication

2001-08-31 Thread Todd Goldenbaum
hi, I am setting up replication between two servers, and I have it working for the most part- however- when I do cross-database updates, the changes don't go through to the slave. as in: use mysql; update test.test_table set a=1; I followed the instructions in the manual for replicating