使用C++ api 实现sqlite3数据库中添加组合索引 及删除

使用C++ api 实现sqlite3数据库中添加组合索引

//idx_combined 是用户指定的索引名称，your_table 是表名，column1 和 column2 是要包含在组合索引中的列名
#include <iostream>
#include <sqlite3.h>

int main() {
    sqlite3* db;
    char* errMsg = 0;
    int rc = sqlite3_open("your_database.db", &db);

    if (rc) {
        std::cerr << "Can't open database: " << sqlite3_errmsg(db) << std::endl;
        return(0);
    }

    const char* sql = "CREATE INDEX idx_combined ON your_table(column1, column2)";

    rc = sqlite3_exec(db, sql, 0, 0, &errMsg);

    if (rc != SQLITE_OK) {
        std::cerr << "SQL error: " << errMsg << std::endl;
        sqlite3_free(errMsg);
    } else {
        std::cout << "Combined index created successfully" << std::endl;
    }

    sqlite3_close(db);
    return 0;
}

删除索引

#include <iostream>
#include <sqlite3.h>

int main() {
    sqlite3* db;
    char* errMsg = 0;
    int rc = sqlite3_open("your_database.db", &db);

    if (rc) {
        std::cerr << "Can't open database: " << sqlite3_errmsg(db) << std::endl;
        return(0);
    }

    const char* sql = "DROP INDEX idx_combined";

    rc = sqlite3_exec(db, sql, 0, 0, &errMsg);

    if (rc != SQLITE_OK) {
        std::cerr << "SQL error: " << errMsg << std::endl;
        sqlite3_free(errMsg);
    } else {
        std::cout << "Index deleted successfully" << std::endl;
    }

    sqlite3_close(db);
    return 0;
}