我正在使用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
之间以及history
和ORDER
之间的空格字符-尝试:
QSqlQuery q = db_.exec("SELECT * "
"From history "
"ORDER BY id ASC;");
关于sql - 简单的sqlite查询,升序排列,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/29078386/