Thread: ALTER

  1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I'm trying to change the value of a field in a table so for example, if the form is submitted it should change the old_value of the variable test_var to value2. I think it is something like: alter $table set test_var=$value2 where $old_value

    it doesn't work and i don't know from there. I read the mysql docs but it's kind of confusing.

    I apreciate your help!

  2. #2
  3. No Profile Picture
    rod k
    Devshed Newbie (0 - 499 posts)
    You don't want ALTER, that changes the table structure. To change a value you want to use UPDATE.

Similar Threads

  1. Newbie: can't ALTER TABLE from asp page...
    By caspyderman in forum MS SQL Development
    Replies: 4
    Last Post: March 26th, 2004, 07:06 AM
  2. alter table
    By weebeng in forum Oracle Development
    Replies: 3
    Last Post: January 29th, 2004, 04:36 AM
  3. alter databse
    By fxthomas in forum MySQL Help
    Replies: 1
    Last Post: October 28th, 2003, 11:01 PM
  4. Slow alter table/sum queries on large InnoDB table
    By ddipetrillo in forum MySQL Help
    Replies: 0
    Last Post: April 17th, 2003, 11:27 AM
  5. Replies: 7
    Last Post: July 8th, 2002, 11:06 AM

IMN logo majestic logo threadwatch logo seochat tools logo