[sqlite] to table update

update tb1 set col1=(select col1 from tb2 ) where tb1.co2=tb2.co2; it couldn't work ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to process password

I need insert any my bank-card information to sqlite db, so when I insert the car number like '3312' and car password like '7711', but I wanna nobody can see the password, so I create a function encode('7711','key') and decode(select from stable where carnum=3312, 'key') to see the password, the