Syntax: execSQL(String SQL, Object bind Args) The execSQL() method is used not only to insert a data, but also to update or modify the existing data in database, using bind arguments. This method is defined in SQLiteDatabse class. The execSQL() method is used to insert the data into table.

Syntax SQLiteDatabse mydatabase = openOrCreateDatabase (“database_name”, MODE_PRIVATE, null) This method returns an instance of SQLite database. The openOrCreateDatabase() method is called for creating a database with your database name and mode as a parameter. The is the main package in Android SQLite which contains the classes to manage your own databases.

To use the SQLite database, the SQLiteOpenHelper class is used which provides various functionality.

It stores data to a text file on a device and supports all the relational database features.

SQLite database is embedded in every Android device.

Android does not require a setup procedure or administration of the database using an SQLite database.

It has methods to create, delete, execute SQL commands and perform other common database management tasks.

It supports standard relational database features like SQL syntax, transactions, prepared statement, etc. What is SQLite?SQLite is an open source database.

Sqlitedatabase