Update the value with a value in the table
-
hi all, i want to update the column value with the value already in that column in a table(based on where condition) For example, table 1 -------- id name 1 abc 2 xyz Now i'm appending the value '123' with the value in the column 'name'. the result should be like id name 1 abc123 2 xyz123 How to do this......
-
hi all, i want to update the column value with the value already in that column in a table(based on where condition) For example, table 1 -------- id name 1 abc 2 xyz Now i'm appending the value '123' with the value in the column 'name'. the result should be like id name 1 abc123 2 xyz123 How to do this......
update table set name = name + '123'
--------------------------- Blogging about SQL, Technology and many other things
-
update table set name = name + '123'
--------------------------- Blogging about SQL, Technology and many other things