Re: [sqlite] UPDATE statement without FROM clause

On Sat, 4 Jun 2016 18:18:36 +0200 skywind mailing lists wrote: > At the moment I have to run something like: > > UPDATE A SET item1=(SELECT B.item FROM B WHERE B.ID=A.ID),... > itemN=... WHERE EXISTS (SELECT 1 FROM B WHERE B.ID=A.ID); > > Using a FROM clause I just

Re: [sqlite] SQL / SQLite for Beginners

On Thu, 26 May 2016 10:54:30 -0400 r.a.n...@gmail.com wrote: > FWIW, since it's inception, S.Q.L has been pronounced allot like > CICS. This may be more true than you know. It's not too hard to find old-timers who pronounce it "kicks". --jkl ___

Re: [sqlite] UPDATE statement without FROM clause

One idea I came up with a while ago is to use a trigger on the "FROM" table to cause updates to the main table: CREATE TRIGGER UpdateTrigger AFTER UPDATE OF TriggerField ON Updates BEGIN UPDATE Master SET Field1 = OLD.Field1, Field2 = OLD.Field2, ... WHERE

Re: [sqlite] SQLite in Android N

On Jun 6, 2016 7:47 PM, "Eric Sink" wrote: > > Official, but slightly vague: > > https://developer.android.com/preview/behavior-changes.html#ndk SQLCipher (based on SQLite) has already dealt with this in: https://github.com/sqlcipher/android-database-sqlcipher/issues/216 I

Re: [sqlite] SQLite in Android N

Official, but slightly vague: https://developer.android.com/preview/behavior-changes.html#ndk >From Xamarin: https://developer.xamarin.com/releases/android/xamarin.android_6/xamarin.android_6.0/ -- E On Mon, Jun 6, 2016 at 12:40 PM, Jason H wrote: > > It is my understanding

Re: [sqlite] SQLite in Android N

> It is my understanding that Android N will no longer allow apps to use the > system-installed SQLite library (unless they go through the Android Java > API, android.database.sqlite). > > This is unfortunate, as many existing Android apps do access libsqlite3 > directly and will crash on Android

[sqlite] SQLite in Android N

It is my understanding that Android N will no longer allow apps to use the system-installed SQLite library (unless they go through the Android Java API, android.database.sqlite). This is unfortunate, as many existing Android apps do access libsqlite3 directly and will crash on Android N. Apps

Re: [sqlite] UPDATE statement without FROM clause

Would not Replace into A () select ,, from A [cross] join B on( ); do the trick? If a.rowid has an alias (i.e. integer primary key) then the modified rows would be deleted, but reinserted with their respective previous rowids. This may required switching foreign keys off fort he duration of