Did my sql statement correct

lieweffect's Avatar, Join Date: Apr 2006
Contributor
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 by lieweffect; 1Aug2006 at 14:23..
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Does it give any error when you run the above query.
lieweffect's Avatar, Join Date: Apr 2006
Contributor
actually, this only from a little test
does any software can test the sql statement whether correct or not?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by lieweffect
does any software can test the sql statement whether correct or not?
Nope but your SQL looks correct.
lieweffect's Avatar, Join Date: Apr 2006
Contributor
Thank Q.....