*** 89,95 **** *: UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it). ! _:: Postgres also allows "UPDATE ... FROM ... ", BTW. _:: I was working on something where I really wanted to use this construct with SQLite, so I came up with the following hack: --- 89,95 ---- *: UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it). ! _:: Postgres also allows "UPDATE ... FROM ... ", BTW. (As does Ingres --CAU) _:: I was working on something where I really wanted to use this construct with SQLite, so I came up with the following hack: *************** *** 131,136 **** --- 131,149 ---- so we would not have to rely on conflict resolution to do essentially the same thing (not exactly the same, since REPLACE is DELETE and INSERT, but sometimes close enough). *< gifford hesketh::2004- Oct-26* + + _:: I've managed successfully to do this an alternative way, works in version 3.2.1 (--CAU:18-Aug-2005) ... + + -- + -- emulating "UPDATE ... FROM" in SQLite + -- + -- + UPDATE + t1 + SET + measure = ( SELECT measure FROM t2 WHERE t2.key = t1.key ) + ; + *: Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|