sql - Simple sqlite query with ascending order -

I have been working with QT and using sqlite when I write it:

  QSqlQuery q = db_.exec ("Select '" "from history";);  

It works as expected, but I did not find anything with it:

  QSqlQuery q = db_.exec ("SLECT *" "History "" By ORDER ID ASC;);  

This table is created:

  db_.exec ("If no history exists then create table (" ID primary primary attribute is not zero, "" URL text, "" real of the day, "" real of the month, "" year real, "" real, "" minute real, "" second real "););   
 Thanks   
 
 
  except for select  *  and  between  and  history  and  ORDER  - try: 
 
  QSqlQuery Q = db_.exec ("SELECT *" "from history" "ORDER id asc";);