So I have a table and I want to create another table using “CREATE VIEW” from sql. I need to make a copy of the table that I am working with so I can use it 2x. My sql query would have to be like this: my initial table is: so anyone has any ideea where (in my code) I
Tag: android
SQLite in Android How to update a specific row
I’ve been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I’ve read and tried, you can just use the: execSQL(String sql) method or the: update(String table, ContentValues values, String whereClause, String[] whereArgs) method. (Let me kno…
Android – sqlite in clause using values from array
I want to execute a sqlite query: The values in the in clause need to be taken from an array of strings: How can I achieve that? Answer I believe a simple toString() will mostly do the trick:
Exit the SQLite shell on Android
I’m using SQLite 3 on Mac OS X’s ADB shell to view my application database using: After I wrongly typed the quit command above, instead of the .quit for example, the shell goes into the …> prompt where none of the known commands seem to work. I can’t even get out by Ctrl + C, Ctrl +…
How do I reference sqlite db column to use in update statement
I am trying to update a datetime column in an android sqlite db to use international date format (yyyy-mm-dd) instead of the current format (mm/dd/yyyy). I want to use the sqlite date() function to reformat the current value of the column. I thought it would be as simple as the following: but the above does n…