我正在使用QT并使用sqlite。当我写这个:

QSqlQuery q = db_.exec("SLECT *"
                       "From history;");


它按预期工作,但与此无关:

QSqlQuery q = db_.exec("SLECT *"
                       "From history"
                       "ORDER BY id ASC;");


这是表的创建:

db_.exec("CREATE TABLE IF NOT EXISTS history ("
          "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
          "url TEXT,"
          "day REAL,"
          "month REAL,"
          "year REAL,"
          "hour REAL,"
          "minute REAL,"
          "second REAL"
          ");");


谢谢

最佳答案

除了SELECT缺少E之外,您可能还需要*From之间以及historyORDER之间的空格字符-尝试:

QSqlQuery q = db_.exec("SELECT * "
                       "From history "
                       "ORDER BY id ASC;");

关于sql - 简单的sqlite查询,升序排列,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/29078386/

10-08 22:32
查看更多