6 个解决方案
#1
select col1,col2,1 as col3 from table1
#2
也可:
select col1,col2,col3=1 from table1
select col1,col2,col3=1 from table1
#3
或者
select col1,col2,col3 = 1 from table1
select col1,col2,col3 = 1 from table1
#4
前一种可以,后面的不行。总之解决了,谢谢!
#5
select col1, col2, 1 as col3 from table1
#6
我来学习一下
#1
select col1,col2,1 as col3 from table1
#2
也可:
select col1,col2,col3=1 from table1
select col1,col2,col3=1 from table1
#3
或者
select col1,col2,col3 = 1 from table1
select col1,col2,col3 = 1 from table1
#4
前一种可以,后面的不行。总之解决了,谢谢!
#5
select col1, col2, 1 as col3 from table1
#6
我来学习一下