The post explains quite well the drawbacks of some of the solutions that I also went through, but their final solution can also leave you in trouble. Student.kt package reading this blog post (and a few others) on how to use the onUpgrade() method for your Android SQLite Database, I thought I should share my experience about how to correctly upgrade your database. It will also be beneficial to highlight why the final solution listed in that blog post would also fail at some point for some scenarios. Private const val COLUMN_NAME = 'StudentName' Private const val COLUMN_ID = 'StudentID' Private const val TABLE_STUDENTS = 'students' Private const val DATABASE_NAME = 'studentDB.db' Val query = 'Select*FROM $TABLE_STUDENTS WHERE $COLUMN_ID = '$ID''ĭb.delete(TABLE_STUDENTS, '$COLUMN_ID=?', arrayOf( class MyDBHandler internal constructor(context: Context?) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) ', null) > 0

In onCreate() method we will create student table. First time on constructor (MyDBHandler) call we will create our database. MyDBHandler class is our database handler class which extends SQLiteOpenHelper class to manage database operations. StepsĢ) Run and test your app 1) Code Database Operations in your app In our main screen we will perform CRUD operation i.e create, read, update and delete student record. In our example we have Student Database table containing StudentID and StudentName as columns. In this article we will learn how to perform CRUD operation in Sqlite Database Android (Example Code).

Sqlite kotlin