Update a table value with out using update command

Question

Is it possible to update a table value with out using update command? if yes what is the reason, if no what is the reason?

Aarti · Answer

Hi Arjun, use Replace command replace into tablename(primary key,....{rest of the columns in the table}) values(the same primary key, new values ); this will delete the previous row and insert a new row with the same primary key and updated column values. I hope it will help you.. Thanks.

Pravin More · Answer

my pleasure Arjun, please mark accepted answer if like . Thanks, Pravin

Aarti · Answer

Yes Arjun... update command is for updation but your question was Update a table value with out using update command then i suggest by using Replace we can update value of table. :)

Arjun Panwar · Answer

I am agree with Pravin ,because update command is used only for update. Thanks for giving the best answer.

Pravin More · Answer

replace into..... is 1 more syntax to update in mysql...sql server doesnt support it......... but arjun my point was when we look for something other that update statement?? is when we dont have permision to update....so when someone dont have permision for "Update" he even dont have it for "replace into" too..... Thanks, Pravin.

Arjun Panwar · Answer

Hi, Mr Pravin do you agree with Deepika reply ?

Pravin More · Answer

Hi Arjun, its not possible without update command n the reason is........ if yes then some user dont have pevilage to update even he can update......it will voilate access rights. if you have insert delete permision then can do 1 thing delete n reinsert that row with new record....but this is worst solution as if someone dont have update rights then he dont have insert,delete rights too.... Thanks,i hope i am specific to you quetion. Pravin.

dev 0 · Answer

Hi Arjun , Use merge command. If the rows already exist then it will update it with new data if not it would insert the new data Hope this will help you. Thanks

Update a table value with out using update command

Answers (8)