I have a table
flaggedcomment and a table
flaggedcomment, there are two empty columns
Price_Open which I want to copy from
price, depending on the
ON conditions. Query as below.
UPDATE flaggedcomment as t1 LEFT JOIN price as t2 ON t1.Ticker_Ticker_ID = t2.Ticker_Ticker_ID AND t1.Comment_DateTime = t2.Price_DateTime SET t1.Price_DateTime = t2.Price_DateTime, t1.Price_Open = t2.Price_Open
This query will leave some cells with null value because there's no match between
Is there a way to "pick" the next available
Price_DateTime if there's no match found?
For example, if the value of
2014-09-29 20:44:00 but it's not exist in
t2.Price_DateTime, can I pick the next row's
Price_DateTime value, e.g.
I am new to deal with MySQL queries and I've tried my best in explaining what I want to do. If I didn't explain my question well, please let me know and I will try to explain it further.
Any help would be much appreciated. Thank you!