'2013-02-29' as date_end
В феврале 28 дней.
Попробуйте использовать эти SQL запросы:
Код: Выделить всё
UPDATE product_special, etrade_products SET product_special.price=etrade_products.recom_price WHERE product_special.product_id=etrade_products.tov_id;;;
INSERT INTO product_special (product_special_id, product_id, customer_group_id, priority, price, date_start, date_end) SELECT tov_id, tov_id, '1' as customer_group_id,'1' as priority, recom_price, now() as date_start, '2013-02-28' as date_end FROM etrade_products WHERE recom_price>0 AND tov_id NOT IN (SELECT product_id FROM product_special GROUP BY product_id);;;