MySQL Forums
Forum List  »  Newbie

SET column = '13:00:00' and increase the next row with '00:00:30'
Posted by: Erik Frøseth
Date: July 09, 2009 05:13AM

Hi there! I'm trying to run a update where I set the first row to be a specific time (for example 13:00:00), and set the next row to increase by a specific interval (if the interval is set to 00:00:30, then the next row would be 13:00:30). But I have no idea how to do it. Could someone help me do this?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
SET column = '13:00:00' and increase the next row with '00:00:30'
July 09, 2009 05:13AM


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.