will the order of columns change when that in the query is changed ?

Question

like : "select name,place from tb1" and "select place,name from tb1"......Will they give the same output order?

Answer 1

yes the columns appear in the same order as they appear in the select statement.

Answer 2

query on the target table will not change the table column but the query result will be at the same order as you write.