title: Copying Data from one table to another with updated date
body: <p>I've two tables 2017_11_08_minute and <strong>2017_11_09_minute</strong>. My <strong>2017_11_08_minute</strong> table is empty. I need to copy all the data from <strong>2017_11_09_minute</strong> to <strong>2017_11_08_minute</strong>. </p>
  
  <p>I've a DATETIME column in my 2017_11_09_minute which has data like 2017-11-09 00:00:20</p>
  
  <p>I need to update this to 2017-11-08 00:00:20 while copying the rest of the data as it is! </p>