C语言数据库sqlite3的基本操作（使用回调函数和不使用回调函数）

#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>

int create_table(sqlite3 * pdb)
{
	char * errmsg = NULL;
    char * sql;
	int ret;

	sql = "create table if not exists mytable (id integer primary key,name text);";

    ret = sqlite3_exec(pdb,sql,NULL,NULL,&errmsg);

	if(SQLITE_OK != ret)
	{
		printf("create table failed! %s\n",errmsg);
		return -1;
	}
	else
	{
		return SQLITE_OK;
	}
}

void insert_record(sqlite3 * pdb)
{
	char * errmsg = NULL;
    char sql[100];
	int ret;
	int id;
	char name[30];

	printf("please input id  and  name:\n");
	scanf("%d%s",&id,name);

	sprintf(sql,"insert into mytable(id,name) values (%d,'%s');",id,name);

    ret = sqlite3_exec(pdb,sql,NULL,NULL,&errmsg);

	if(SQLITE_OK != ret)
	{
		printf("insert error 1! %s\n",errmsg);
		exit(-1);
	}
#if 0
	sql = "insert into mytable values (NULL,'zhang&