Hi all,
I have a set of dates as below:
I wish to rearrange / UPDATE these dates in the DB to have a uniform gap between them like that of 1 or 2 or 3 or 0 or n days and a uniform interval of time ( 2 or 3 or 4 or 5 or n hours) between TimeOfLogin and TomeOfLogout.
What would be the best way to achieve that? Should I i use php for this or is there an all mysql way to achieve this !!
Thanks all !