标题:Qt清空表数据并重置自增列（sqlite+mysql）
作者:liudianwu
日期:2019-04-10 09:07
内容:
void DBHelper::clearData(const QString &tableName)
{
QString sql;
QSqlQuery query;
if (App::LocalDBType.toUpper() == "SQLITE") {
//SQLite数据库自增列信息存储在 sqlite_sequence 表,表包含两个列：name记录自增列所在的表,seq记录当前序号
sql = QString("delete from %1").arg(tableName);
query.clear();
query.exec(sql);
sql = QString("delete from sqlite_sequence where name='%1'").arg(tableName);
query.clear();
query.exec(sql);
} else if (App::LocalDBType.toUpper() == "MYSQL") {
//重置自增主键,用 truncate table table_name 效率高,而不是 alter table table_name auto_increment = 1
sql = QString("truncate table %1").arg(tableName);
query.clear();
query.exec(sql);
}
}
#1 [liulin188 04-10 09:28]
用原始api的飘过~~~