View Single Post
Join Date: Oct 2007
Posts: 280
Reputation: joshmo is an unknown quantity at this point 
Solved Threads: 19
joshmo joshmo is offline Offline
Posting Whiz in Training

problem with update

 
0
  #1
Nov 16th, 2008
I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates simultaneously. Thanks. Here is the code
  1. accept ID prompt 'Enter Old ID:'
  2. accept ID prompt 'Enter New ID:'
  3. accept Name prompt 'Name:'
  4.  
  5. UPDATE table_one
  6. SET ID=REPLACE(ID,'&ID','&ID')
  7. WHERE Name='&Name';
Last edited by joshmo; Nov 16th, 2008 at 8:45 am.
Reply With Quote