INSERT INTO intraday_data VALUES('NYX',20070827141200,20070827,141200,73.82,73.82,73.80,73.80,1800); DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827"; INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.59,73.80,1157731);