# wget http://www.hwaci.com/sw/sqlite/sqlite-2.8.9.tar.gz
# mv sqlite-2.8.9.tar.gz /usr/src
# tar -xvzf sqlite-2.8.9.tar.gz
# cd sqlite
# ./configure
# make 
# make install
            

# sqlite test.db
SQLite version 2.8.9
Enter ".help" for instructions
sqlite> 
            

sqlite> create table test(name char(80), age int);
sqlite> insert into test values("yundream", 19);
sqlite> insert into test values("hello world", 29);
sqlite> select * from test;
yundream|19
hello world|29
            

typedef struct sqlite sqlite;
#define SQLITE_OK

sqlite *sqlite_open(const char *dbname, int mode, char **errmsg);

void sqlite_close(sqlite *db);

int sqlite_exec
(
  sqlite *db,
  char *sql,
  int (*xCallback)(void*,int,char**,char**),
  void *pArg,
  char **errmsg
);
            

            sqlite *sqlite_open(const char *dbname, int mode, char **errmsg);
            

int Callback(void *pArg, int argc, char **argv, char **columnNames))
{
    return 0;
}
            

#define SQLITE_OK           0   /* Successful result */
#define SQLITE_ERROR        1   /* SQL error or missing database */
#define SQLITE_INTERNAL     2   /* An internal logic error in SQLite */
#define SQLITE_PERM         3   /* Access permission denied */
#define SQLITE_ABORT        4   /* Callback routine requested an abort */
#define SQLITE_BUSY         5   /* The database file is locked */
#define SQLITE_LOCKED       6   /* A table in the database is locked */
#define SQLITE_NOMEM        7   /* A malloc() failed */
#define SQLITE_READONLY     8   /* Attempt to write a readonly database */
#define SQLITE_INTERRUPT    9   /* Operation terminated by sqlite_interrupt() */
#define SQLITE_IOERR       10   /* Some kind of disk I/O error occurred */
#define SQLITE_CORRUPT     11   /* The database disk image is malformed */
#define SQLITE_NOTFOUND    12   /* (Internal Only) Table or record not found */
#define SQLITE_FULL        13   /* Insertion failed because database is full */
#define SQLITE_CANTOPEN    14   /* Unable to open the database file */
#define SQLITE_PROTOCOL    15   /* Database lock protocol error */
#define SQLITE_EMPTY       16   /* (Internal Only) Database table is empty */
#define SQLITE_SCHEMA      17   /* The database schema changed */
#define SQLITE_TOOBIG      18   /* Too much data for one row of a table */
#define SQLITE_CONSTRAINT  19   /* Abort due to contraint violation */
#define SQLITE_MISMATCH    20   /* Data type mismatch */
#define SQLITE_MISUSE      21   /* Library used incorrectly */
#define SQLITE_NOLFS       22   /* Uses OS features not supported on host */
#define SQLITE_AUTH        23   /* Authorization denied */
#define SQLITE_ROW         100  /* sqlite_step() has another row ready */
#define SQLITE_DONE        101  /* sqlite_step() has finished executing */
            

#include <stdio.h>
#include <sqlite.h>

static int callback(void *NU, int argc, char **argv, char **azColName)
{
    int i;
    for (i = 0; i < argc; i++)
    {
        printf ("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
    }
    printf("\n");
    return 0;
}
int main(int argc, char **argv)
{
    sqlite *db;
    char *ErrMsg = 0;
    int rc;

    if (argc != 3)
    {
        fprintf(stderr, "Usge : ./testsql [dbname] [query]\n");
        exit(0);
    }
    db = sqlite_open(argv[1], 0, &ErrMsg);
    if (db == 0)
    {
        fprintf(stderr, "Cant open database ; %s\n", ErrMsg);
        exit(0);
    }
    rc = sqlite_exec(db, argv[2], callback, 0, &ErrMsg);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "SQL error : %d\n", ErrMsg);
    }
    sqlite_close(db);
    return 0;
}
            

# gcc -o testsql testsql.c -L/usr/local/lib -lsqlite
            

# ./testsql test.db "select * from test"
name = yundream
age = 19

name = hello
age = 22
# ./testsql test.db "insert into test values(\"kknd\", 56);"
# ./testsql test.db "select * from test"
name = yundream
age = 19

name = hello
age = 22

name = kknd
age = 56