From Wiki

Mysql: Select

1 g�nden eski kayıtları se�mek i�in:

SELECT dom,ext FROM domains WHERE record_date < DATE_SUB(CURDATE(),INTERVAL 1 DAY)

SELECT * FROM products WHERE id IN (SELECT id FROM safe_products)

SELECT * INTO OUTFILE '/tmp/prods.txt' FROM products;

Retrieved from http://kozgun.net/wiki/pmwiki.php?n=Mysql.Select
Page last modified on March 24, 2006, at 12:16 AM