#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2009
    Posts
    16
    Rep Power
    0

    How to delete from SQLite


    Hi every one
    i want to run a delete query with limitation .
    I've tried to many queries but they didn't work .
    For know , I just want to remove all the rows and I write this code "

    DELETE FROM tbl1 where _id IN(select _id from tbl1 WHERE cat=21)

    The emulator runs perfectly without any error .
    right now , I have 32 rows with cat = 21 .

    could you help me to solve this problem ?

    Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0
    The delete query only allows for modifiers after the DELETE 'command' to tell the database what/how do handle things.

IMN logo majestic logo threadwatch logo seochat tools logo