INSERT INTO intraday_data VALUES('BHP',20070827135500,20070827,135500,62.03,62.04,62.03,62.04,300);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,62.04,810490);