Things to chase after

MySQL specific?

select make_set(255,’bit0′,’bit1′,’bit2′,’bit3′,’bit4′,’bit5′,’bit6′,’bit7′);

select (1,2,3)=(1,2,3);

MySQL FULL OUTER JOIN

But the first two joins—the inner join, and the left exclusion join—are logically equivalent to a left outer join, so we can write:


SELECT * FROM a LEFT JOIN b ON a.id=b.id
UNION ALL
SELECT * FROM a RIGHT JOIN b ON a.id=b.id WHERE a.id IS NULL;

+------+------+------+------+
| id   | name | id   | name |
+------+------+------+------+
|    1 | a    | NULL | NULL |
|    2 | b    |    2 | b    |
|    1 | a    | NULL | NULL |
| NULL | NULL |    3 | c    |
+------+------+------+------+

Why doesn’t MySQL implement FULL OUTER JOIN syntax for this? We don’t know.

via Common Queries Tree.

PURGE MASTER LOGS

PURGE MASTER LOGS TO ‘mydb-bin.0023’;

Then the binlog before ‘mydb-bin.0023’ will be deleted.

You may also do this:

PURGE MASTER LOGS BEFORE ‘2008-06-13 08:00:00’;