SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jul 2003
    Location
    England
    Posts
    23
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Updating a table

    Hi all,

    As i am not that great with databases, i thought i would come here for help.

    what i am wanting to do in my mysql databse is update a table/coloum manually, and i will try to explain below.

    I have a table called: b2b_members in that i have a coloum called Sell_all in that coloum it accepts a Yes or No statement.

    Now that i have addded a new feature to my site, i need Yes added to every record within the Sell_all coloum.

    I am hoping someone can help me with a quick code to do it.

    Thank you
    Kirk

  2. #2
    He's No Good To Me Dead silver trophybronze trophy stymiee's Avatar
    Join Date
    Feb 2003
    Location
    Slave I
    Posts
    23,423
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    UPDATE b2b_members SET Sell_all='Yes'


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •