test.c

#include "sqlite3.h"
#include "sqliteInt.h"
#include "vdbe.h"
#include "vdbeInt.h"
#include "opcodes.h"


static int callback(void *NotUsed, 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[])
{
sqlite3 *db;
sqlite3_stmt *pStmt=NULL;
char *sql,*zerrmsg=0;
int rc,i;
Vdbe *pVdbe;
const unsigned char *zAns;

//open database
rc=sqlite3_open("d.db",&db);
if(rc) {
 fprintf(stderr,"cant open database: %s \n",sqlite3_errmsg(db));
 exit(0);
}

sql="drop table student;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
sql="drop table location;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

//create table
sql="create table student(id int primary key,name text,age int);"\
    "create table location(city text,country text,id int primary key);";

rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

//insert values
sql="insert into student values(1,'sai',20);"\
    "insert into student values(2,'ram',25);"\

    "insert into location values('new york','usa',1);"\
    "insert into location values('london','uk',2);";


rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

 if( rc != SQLITE_OK ) {
  fprintf(stderr, "SQL error: %s\n", zerrmsg);
  sqlite3_free(zerrmsg);
 }
  else {
  fprintf(stdout, "Records created successfully\n");
 }

sql="select * from student,location;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);


if(rc != SQLITE_OK){
 fprintf(stderr, "SQL error: %s\n", zerrmsg);
 sqlite3_free(zerrmsg); }


rc = sqlite3_prepare(db,sql,strlen(sql)+1,&pStmt,NULL);

 if(rc != SQLITE_OK) {
  fprintf(stderr, "SQL error: Prepare Err");
  }

pVdbe = (Vdbe*)pStmt;

  printf("addr opcode           p1  p2   p3 p4            p5       comment\n");
  printf("---- -------------    --  --   -- -----------   --       -------------\n");
   for(i=0;i<pVdbe->nOp;i++) {
   sqlite3VdbePrintOp(stdout,i,&pVdbe->aOp[i]);
 }

sqlite3_close(db);
}