1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Did my sql statement correct

Discussion in 'SQL Server' started by lieweffect, Aug 1, 2006.

  1. lieweffect

    lieweffect New Member

    I have a table=table1 which consists 3 columns
    columns1(data)
    columns2(data)
    columns3(no data but created)

    Now I want to update the data in columns1 into columns3
    My SQL statement like this:UPDATE table1 set Column3=Column1
    Isn't correct?Thank Q
     
    Last edited: Aug 1, 2006
  2. shabbir

    shabbir Administrator Staff Member

    Does it give any error when you run the above query.
     
  3. lieweffect

    lieweffect New Member

    actually, this only from a little test
    does any software can test the sql statement whether correct or not?
     
  4. shabbir

    shabbir Administrator Staff Member

    Nope but your SQL looks correct.
     
  5. lieweffect

    lieweffect New Member

    Thank Q.....
     

Share This Page