MySQL Forums
Forum List  »  General

Re: Calculate sum between rows when time changes
Posted by: Marco Singh
Date: March 04, 2015 12:43PM

It works perfectly, this is how it's done:

LOAD DATA LOCAL INFILE 'C:/test.csv'
INTO TABLE tbltest
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(curr,@t,bid,ask)
set timestamp=concat(str_to_date(left(@t,8),"%Y%m%d"), right(@t,13));

I now have a fast and well functioning query thanks to you, amazing that people like you exist :-)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.