Backup of 2008-04-22 (No. 1)

• Backup list
• View the diff.
• View the diff current.
• View the diff for visual.
• View the source.
• Go to 2008-04-22.
  • 1 (2008-04-22 (Tue) 20:23:54)

• 「MySQLのUsing Filesort」クエリーの分割
  • http://d.hatena.ne.jp/kenji-u/20071102/p1

select * from tbl where a = 1 and b = 1 order by c;

CREATE TEMPORARY TABLE tmp1 SELECT * FROM tbl  WHERE a = 1;
CREATE TEMPORARY TABLE tmp2 SELECT * FROM tmp1 WHERE b = 1;
SELECT * FROM tmp2 ORDER BY c;