# 安裝sqlite3
sudo apt install sqlite3 libsqlite3-dev
sqlite3 --version
sqlite3 test.db
# 安裝sqlitebrowser
sudo apt-get install sqlitebrowser
sqlitebrowser test.db

.databases：列出當(dāng)前連接的數(shù)據(jù)庫
.tables：列出當(dāng)前數(shù)據(jù)庫中的表
.schema tablename：顯示指定表的結(jié)構(gòu)
CREATE TABLE tablename (column1 datatype, column2 datatype, ...);：創(chuàng)建表
INSERT INTO tablename (column1, column2, ...) VALUES (value1, value2, ...);：插入數(shù)據(jù)
SELECT * FROM tablename;：查詢表中的數(shù)據(jù)
UPDATE tablename SET column1=value1, column2=value2 WHERE condition;：更新表中的數(shù)據(jù)
DELETE FROM tablename WHERE condition;：刪除表中的數(shù)據(jù)
.exit：退出命令行

#include <iostream>
#include <sqlite3.h>
int main(int argc, char** argv) {
    sqlite3* db;
    char* errorMsg = nullptr;
    // 打開或創(chuàng)建數(shù)據(jù)庫文件
    int rc = sqlite3_open("example.db", &db);
    if (rc != SQLITE_OK) {
        std::cout << "無法打開數(shù)據(jù)庫: " << sqlite3_errmsg(db) << std::endl;
        return rc;
    }
    // 創(chuàng)建表
    const char* createTableQuery = "CREATE TABLE IF NOT EXISTS employees (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)";
    rc = sqlite3_exec(db, createTableQuery, nullptr, nullptr, &errorMsg);
    if (rc != SQLITE_OK) {
        std::cout << "無法創(chuàng)建表: " << errorMsg << std::endl;
        sqlite3_free(errorMsg);
        sqlite3_close(db);
        return rc;
    }
    // 插入數(shù)據(jù)
    const char* insertDataQuery = "INSERT INTO employees (id, name, age) VALUES (1, 'Alice', 25)";
    rc = sqlite3_exec(db, insertDataQuery, nullptr, nullptr, &errorMsg);
    if (rc != SQLITE_OK) {
        std::cout << "無法插入數(shù)據(jù): " << errorMsg << std::endl;
        sqlite3_free(errorMsg);
        sqlite3_close(db);
        return rc;
    }
    // 查詢數(shù)據(jù)
    const char* selectDataQuery = "SELECT * FROM employees";
    rc = sqlite3_exec(
        db,
        selectDataQuery,
        [](void* data, int argc, char** argv, char** colNames) -> int {
            for (int i = 0; i < argc; i++) {
                std::cout << colNames[i] << " = " << argv[i] << std::endl;
            }
            return 0;
        },
        nullptr,
        &errorMsg
    );
    if (rc != SQLITE_OK) {
        std::cout << "無法查詢數(shù)據(jù): " << errorMsg << std::endl;
        sqlite3_free(errorMsg);
        sqlite3_close(db);
        return rc;
    }
    // 關(guān)閉數(shù)據(jù)庫連接
    sqlite3_close(db);
    return 0;
}

g++ -o main main.cpp -lsqlite3 && ./main