This is my scenario
I have a table t with following columns
id int link varchar(500) name varchar(20) sal text
In the link column we will store the location for the pdf files(mount point)
there will be one link for every id
Application Users have changed their pdf file location from
Now how can i update the table with new location for all the rows. Table contains nearly 10,000 rows
Note:id and link are related every id contains unique link.