Here we learn about the sqlite3 in C language.
Sqlite3:
-It is the module by which we can deals with the database that can be also handled by almost every programming language and C language too.
How we include this module in C program ?
-We just need to include following line in program
#include< sqlite3.h>
Functions that are used :
1. sqlite3_open()
2. sqlite3_exec()
3. sqlite3_close()
1. sqlite3_open():
This is the function that are used to create new database or open the existing database.
Syntax-
sqlite3_open("database_name", sqlite3 **db)
Where,
db is the sqlite3 pointer.
2. sqlite3_exec():
This is the function which are used in execute the sql query.
Syntax-
sqlite3_exec(db_pointer,query,callback,char,**errmsg)
3. sqlite3_close():
This function is use for the close the database connection.
Syntax-
sqlite3_close(db_pointer);