android.database.sqlite.SQLiteException

near "=": syntax error (code 1): , while compiling: DELETE FROM `Article` WHERE `mId` NOT IN (SELECT `A`.`mId` FROM `Article` AS `A` INNER JOIN `Message` AS `M` ON `M`.`mArticleId_mId`=`A`.`mId` ,`mWatched`=0)

Solutions on the web1828

  • near "=": syntax error (code 1): , while compiling: DELETE FROM `Article` WHERE `mId` NOT IN (SELECT `A`.`mId` FROM `Article` AS `A` INNER JOIN `Message` AS `M` ON `M`.`mArticleId_mId`=`A`.`mId` ,`mWatched`=0)
  • via Stack Overflow by Salvo
    , 1 year ago
    near "=": syntax error (code 1): , while compiling: SELECT app_filter, comp_description FROM (SELECT app_filter, comp_description, app_id, CO._id AS 'comp_id' FROM app AS A JOIN component AS CO ON A._id = CO.app_id ) AS Y JOIN (SELECT receiver_id
  • via Stack Overflow by java progammera
    , 1 year ago
    near "(": syntax error (code 1): , while compiling: select * from appointments_table where strftime ('%d.%m.%Y', date) > now.strftime('%d.%m.%Y')
  • Stack trace

    • android.database.sqlite.SQLiteException: near "=": syntax error (code 1): , while compiling: DELETE FROM `Article` WHERE `mId` NOT IN (SELECT `A`.`mId` FROM `Article` AS `A` INNER JOIN `Message` AS `M` ON `M`.`mArticleId_mId`=`A`.`mId` ,`mWatched`=0) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 2 weeks ago
    68 times, 6 days ago
    14 times, 3 weeks ago
    2 times, 1 month ago
    Unknown user
    Once, 2 months ago
    108 more bugmates