View difference between Paste ID: yLx1L0uu and WYJ74EEt

 #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;
 
    for(i=0;i<pVdbe->nOp;i++) {
-  printf("addr opcode           p1  p2   p3 p4            p5       comment\n");
+
-  printf("---- -------------    --  --   -- -----------   --       -------------\n");
+
 
 sqlite3_close(db);
 }