Thursday, July 22, 2010

Cross Table Delete with MySQL

DELETE product.*, productPrice.*
FROM product p, productPrice pp
WHERE p.productId = pp.productId
AND p.created < '2004-01-01'

No comments:

Post a Comment