#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Sydney
    Posts
    1
    Rep Power
    0

    Updating a table


    I have to write a script to update a table named PA with a column heading of testone update the qty from 10 to 20?

    Please help me ASAP for the above request.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    update PA set testone = 20 where testone = 10;

    You should really get a decent SQL tutorial if you don't know how to do it!

IMN logo majestic logo threadwatch logo seochat tools logo