3

#include "../../common/sqlite-amalgamation-3220000/sqlite3.h"
#include <stdio.h>

const char szSql[] =
"SELECT 2+2, 3*3;"
"CREATE TABLE users(id INT NOT NULL, email VARCHAR(20) NOT NULL);"
"INSERT INTO users (id, email) VALUES (1, 'nobody@noserver.net');"
"SELECT rowid, * FROM users;"
"INSERT INTO users (rowid, id, email) VALUES (2019, 1, 'nobody@noserver.net');"
"HELLO";

int main(void) {
    sqlite3 *db;
    int      nErrNr;
    sqlite3_stmt* st;
    const char *pErr;
    char* tail;
    int nColCnt;
    int i;
    nErrNr = sqlite3_open("MyFirstDb", &db);
    nErrNr = sqlite3_prepare(db, "SELECT ?+?, ?*?", -1, &st, &tail);
    if (nErrNr) {
        pErr = sqlite3_errmsg(db);
        printf("%s\n", pErr);
    }
    nErrNr = sqlite3_bind_int(st, 1, 2);
    nErrNr = sqlite3_bind_int(st, 2, 2);
    nErrNr = sqlite3_bind_int(st, 3, 2);
    nErrNr = sqlite3_bind_int(st, 4, 2);
    while ((nErrNr = sqlite3_step(st)) == SQLITE_ROW) {
        nColCnt = sqlite3_column_count(st);
        for (int i = 0; i < nColCnt; ++i) {
            printf("%s=%s\t", sqlite3_column_name(st, i), sqlite3_column_text(st, i));
        }
        printf("\n");
    }
    if (nErrNr != SQLITE_DONE) {
        pErr = sqlite3_errmsg(db);
        printf("%s\n", pErr);
    }
    nErrNr = sqlite3_finalize(st);
    sqlite3_close(db);
    system("pause");
    return 0;
}