postgresql - SQL statements to replace specific cell data -


i want update data in specific cell. have googled , know need use update, of examples seeing show how change data in batches not single cell , don't want mess up.

so here example of answer table;

id | answer | user | location  1  | ans 1  | usr1 | loc 1 2  | ans 2  | usr2 | loc 2 3  | ans 3  | usr3 | loc 3 4  | ans 4  | usr4 | loc 4 

so if wanted change user usr3 usr2 in record 3, how write that?

thanks!

update answer set user = 'usr2' id = 3; 

Comments

Popular posts from this blog

javascript - how to protect a flash video from refresh? -

android - Associate same looper with different threads -

visual studio 2010 - Connect to informix database windows form application -