java - Android Sqlite不支持 update where select吗
PHPz
PHPz 2017-04-17 17:51:34
0
1
276
UPDATE event
SET EVENT_PROCESS = 4
WHERE
    LEARNING_EVENT_GROUP_ID IN (
        SELECT DISTINCT
            LEARNING_EVENT_GROUP_ID
        FROM
            event
        WHERE
            EVENT_TYPE = 1
        AND EVENT_PROCESS != 4
        AND (
            (
                (
                    EVENT_SEQUENCE = 1
                    OR EVENT_SEQUENCE = 2
                )
                AND 1463681631460 >= (
                    EVENT_EXPECTED_FINISHED_DATE + 86400000
                )
            )
            OR 1463681631460 >= (
                EVENT_EXPECTED_FINISHED_DATE + 172800000
            )
        )
    )

这是我的sql,在Sqlite Navicat里面可以执行,但是在Android里面不报错,但就是没效果,是Android不支持这种形式的sql吗

PHPz
PHPz

学习是最好的投资!

reply all(1)
迷茫

There is no problem with the syntax of SQLite, but have you ever considered whether you use the package required to call sqlite on Android? That is a Java implementation method, not a command line

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template