On Wed, 9 May 2012 02:24:58 +0100 Simon Slavin <slav...@bigfraud.org> wrote:
> alter table myref add stkcode varchar(30); > update myref set stkcode = dzhhq.stkcode; > > this sql command couldn't run in my sqlite. It does not know which row from the table dzhhq it is meant to use. Simon. I means: use another table column, to update the current table column: like this: alter table myref add upfu; update myref set upfu =dzhhq.upfu where exists (select * from dzhhq where myref.stkname=dzhhq.stkname); but it said no such column: dzhhq.upfu but dzhhq.upfu really exist. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
