On 10 Feb 2012, at 5:55pm, Kit wrote: > 2012/2/10 Simon Slavin <slav...@bigfraud.org>: >> On 10 Feb 2012, at 5:32pm, Kit wrote: >>> A situation in which I read from the database first and then changes >>> the data tells me that they are wrong questions. It is such a problem >>> to insert SELECT into UPDATE or INSERT? >> >> Why do you need to do a SELECT at all ? Can you present us with a simple >> example of your situation ? >> Simon. > > Add value from Alpha to Bravo: > > Wrong: > SELECT val AS val1 FROM t1 WHERE name='Alpha'; > UPDATE t1 SET val=val+val1 WHERE name='Bravo'; > > Good: > UPDATE t1 SET val=val+(SELECT val FROM t1 WHERE name='Alpha') WHERE > name='Bravo'; > > No explicit transaction, no problem.
Ah, you were suggesting the solution, not asking the question. I misunderstood. Sorry. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
