[lieweffect]

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

[shabbir]

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

[lieweffect]

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

[shabbir]

Quote:

Originally Posted by lieweffect

does any software can test the sql statement whether correct or not?

Nope but your SQL looks correct.

[lieweffect]

Thank Q.....