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
actually, this only from a little test does any software can test the sql statement whether correct or not?