title: mySQL query to return last record for each table
body: <p>I have a mySQl db (name "stocks") with 50 tables, each tables with </p>
  
  <p>id, symbol, date, time, open, high, low, close, volume as columns (9 columns).</p>
  
  <p>I would like to know what is the last record for each table, ordered for date then time.</p>
  
  <p>Should I have to ORDER BY all data for each table or there is a better way to just know last record?</p>
  
  <p>I am asking help for a query that just return only last record for each table in db.</p>
  
  <p>Thanks </p>
  
  <p>PS For last record I mean most recent as Date then Time</p>