Introduction to Database and sqlite3 by R4R Team

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);




Leave a Comment: