INSERT INTO intraday_data VALUES('ECA',20070827141700,20070827,141700,58.31,58.33,58.27,58.27,5200); DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827"; INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.27,980286);