you can use delete query to delete data from table . where you provide null to delete evey things from it .
On Mon, Mar 28, 2016 at 11:20 PM, Elijah Smith < [email protected]> wrote: > I have this SQL statement that I want to execute: > > db.execSQL("DELETE * FROM " + TABLE_NAME + " WHERE " + DATE_TO_REMIND + "='" > + date + "'"); > > > Which, if I were running it today, translates to: > > > "DELETE * FROM Vocabulary WHERE dateToReming ='2016/03/28'" > > > This is throwing errors in the logcat though that point to the *, but I > can't understand what it is saying is faulty about this statement. Here is > the error: > > java.lang.RuntimeException: Unable to start activity >>> ComponentInfo{nuffsaidm8.me.activeenglish/nuffsaidm8.me.activeenglish.CheckVocabActivity}: >>> android.database.sqlite.SQLiteException: near "*": syntax error (code 1): , >>> while compiling: DELETE * FROM Vocabulary WHERE Date_To_Remind='2016/03/28' >> >> >>> at >>> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2416) >> >> >>> at >>> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476) >> >> >>> at android.app.ActivityThread.-wrap11(ActivityThread.java) >> >> >>> at >>> android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344) >> >> >>> at android.os.Handler.dispatchMessage(Handler.java:102) >> >> >>> at android.os.Looper.loop(Looper.java:148) >> >> >>> at android.app.ActivityThread.main(ActivityThread.java:5417) >> >> >>> at java.lang.reflect.Method.invoke(Native Method) >> >> >>> at >>> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726) >> >> >>> at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) >> >> >>> Caused by: android.database.sqlite.SQLiteException: near "*": syntax >>> error (code 1): , while compiling: DELETE * FROM Vocabulary WHERE >>> Date_To_Remind='2016/03/28' >> >> >>> at >>> android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native >>> Method) >> >> >>> at >>> android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887) >> >> >>> at >>> android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498) >> >> >>> at >>> android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) >> >> >>> at >>> android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) >> >> >>> at >>> android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) >> >> >>> at >>> android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674) >> >> >>> at >>> android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605) >> >> >>> at >>> nuffsaidm8.me.activeenglish.DBHelper.getWordsToReview(DBHelper.java:77) >> >> >>> at >>> nuffsaidm8.me.activeenglish.CheckVocabActivity.onCreate(CheckVocabActivity.java:55) >> >> >>> at android.app.Activity.performCreate(Activity.java:6251) >> >> >>> at >>> android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107) >> >> >>> at >>> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369) >> >> >>> at >>> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476) >> >> >>> at android.app.ActivityThread.-wrap11(ActivityThread.java) >> >> >>> at >>> android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344) >> >> >>> at android.os.Handler.dispatchMessage(Handler.java:102) >> >> >>> at android.os.Looper.loop(Looper.java:148) >> >> >>> at android.app.ActivityThread.main(ActivityThread.java:5417) >> >> >>> at java.lang.reflect.Method.invoke(Native Method) >> >> >>> at >>> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726) >> >> >>> at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) >> >> -- > You received this message because you are subscribed to the Google Groups > "Android Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/android-developers. > To view this discussion on the web visit > https://groups.google.com/d/msgid/android-developers/acbf2bb0-076c-4957-a69f-0b9510e45b10%40googlegroups.com > <https://groups.google.com/d/msgid/android-developers/acbf2bb0-076c-4957-a69f-0b9510e45b10%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/android-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/CABHzXARJHWtFR6Nu%3D%3DOBbT8ncKFpQGN5jYaQPNUpGoqanSHo4w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
