Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Basic alter question

    Hello I am very new to MySQL. I have a table called "products" and there is a field called "demo" in "products". The field "demo" has values as 1s and 0s. I want to change all the 1s to 0s by a simple query. Any help please?

  2. #2
    Join Date
    Aug 2003
    Posts
    328
    update products
    set demo=0 where demo=1

Posting Permissions

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