Wiki | Mysql / Select

Mysql.Select History

March 24, 2006, at 12:16 AM by 85.105.66.26

Changed line 8 from:

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

to:

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

Added line 12:

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

March 24, 2006, at 12:13 AM by 85.105.66.26

Added line 8:

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

Added line 10:

March 23, 2006, at 11:15 PM by 85.105.66.26

Added lines 1-16:

1 g�nden eski kayıtları se�mek i�in: (:code:) SELECT dom,ext FROM domains WHERE record_date < DATE_SUB(CURDATE(),INTERVAL 1 DAY)

(:code:) (:code:) (:code:) (:code:) (:code:)