No self-introduction
Loading
Profile
Follow
codes (1)
Simple creation and insertion of database
no vote
#include #include "sqlite3.h"int callback(void *msg,int num,char **rom,char **col){int i;for(i=0;i<num;i++){printf("%s=%s ",*(col+i),*(rom+i));}printf("\n");return 0;}int main(int argc,char **argv){int ret;sqlite3 *db = NULL;// = malloc(sizeof(void*));ret = sqlite3_ open(" xx.db" ;,&db);if( SQLITE_ OK != ret ){printf("sqlite3_ open %s\n",sqlite3_ errmsg(db));return -1;}char *errmsg;ret = sqlite3_ exec(db,"create table if not exists stu (no int identity(1,1) primary key ,name char(10),score int)",NULL,NULL,&errmsg);if( SQLITE_ OK != ret ){printf("sqlite3_ exec %s\n",errmsg);printf("sqlite3_ exec %s\n",sqlite3_ errmsg(db));return -1;}ret = sqlite3_ exec(db,"insert into stu (name ,score)values ('zhang
xuqiang2525 0 0
1
No more~
Follows0
Fans0