Compare 2 resultsets from 1 table

Hi, I'd like to do the following in mysql: I have a table with field1 and field2. Both fields are not unique. Field2 can have the value of 0 or 1. I'd like to join the results of these two queries: query 1: select field1, count(field2) as total from table1 group by field1 query 2: select fiel

Dual master/slave config

chine should then (manually) reboot and the database should start to catch up with be new master. - Are the any of you that have experience with this kind of setup? How did you do it? Any info on this would be great. Cheers, Danny Kruitbosch sql, mysql,

Re: Dual master/slave config

ailover. The >failed machine should then (manually) reboot and the database should start >to catch up with be new master. > >- Are the any of you that have experience with this kind of setup? How did >you do it? > > >Any info on this would be great. > > >Cheers, >

Stop query after first match

d limit the results afterwards by using LIMIT 1). This is mainly for boosting the performance of mys queries. Actually where using mysql to dynamically assign ip addresses to our dial-in users. We query the database for available addresses -> there are more than 1 available but I only need 1! Th