how to create update query based on select query
Posted on 2014-08-03
Hi, lets say I have one table called mytabletest and this table have a lots of collumns and rows but i want to select just the row that have collum id=10 and base on the result create one update query to update the same row on the same table on another database. So I will copy this update query inside one file and execute this on the other database to update just this id=10. But I don't want to give the others collumns names since is too much, so is there any way to get the collumns names when i am selecting.