Qt清空表数据并重置自增列（sqlite+mysql）

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 = 1sql = QString("truncate table %1").arg(tableName);query.clear();query.exec(sql);}}