Skip to content

Instantly share code, notes, and snippets.

@Ochornma
Created June 15, 2020 15:58
Show Gist options
  • Select an option

  • Save Ochornma/d6bca896bc3a0712c11056f7cdeac0a1 to your computer and use it in GitHub Desktop.

Select an option

Save Ochornma/d6bca896bc3a0712c11056f7cdeac0a1 to your computer and use it in GitHub Desktop.
database.execSQL("CREATE TABLE IF NOT EXISTS note_table_Tmp (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, service TEXT NULL, date TEXT , speaker TEXT, topic TEXT, description TEXT, point1 TEXT, point1_description TEXT, point2 TEXT, point2_description TEXT, point3 TEXT, point3_description TEXT, point4 TEXT, point4_description TEXT, decision TEXT)")
database.execSQL("INSERT INTO note_table_tmp(id, service, date , speaker, topic, description, point1, point1_description , point2 , point2_description , point3 , point3_description , point4 , point4_description , decision) SELECT id, service, date , speaker, topic, description, point1, point1_description , point2 , point2_description , point3 , point3_description , point4 , point4_description , decision FROM note_table")
database.execSQL("DROP TABLE note_table")
database.execSQL("ALTER TABLE note_table_Tmp RENAME TO note_table")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment