SQL How UPDATE command works -


how update command in sql work?
have table 3 columns a,b,c primary key.
values in table (1,2,3),(2,4,5).
suppose want update tuple , set value of column c 4 values of 1.
tuple (1,2,3) deleted , new tuple inserted ?
or values 1,2 kept constant 3 deleted , 4 inserted ?

this should edit table entry not adding new tuple table

update tablename set c='4' a='1' 

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -