Tb:
Col1 Col2 Col3 AutoID
a1 a2 a3 1
b1 b2 b3 2
c1 c2 c3 3AutoID 为主健
得到的 Col4 = col1::col2::col3
得到样式:
Col1 Col2 Col3 AutoID Col4
a1 a2 a3 1 a1::a2::a3
b1 b2 b3 2 b1::b2::b3
c1 c2 c3 3 c1::c2::c3
用mysql语句能实现吗?
Col1 Col2 Col3 AutoID
a1 a2 a3 1
b1 b2 b3 2
c1 c2 c3 3AutoID 为主健
得到的 Col4 = col1::col2::col3
得到样式:
Col1 Col2 Col3 AutoID Col4
a1 a2 a3 1 a1::a2::a3
b1 b2 b3 2 b1::b2::b3
c1 c2 c3 3 c1::c2::c3
用mysql语句能实现吗?
From Tb
select *,concat(Col1,'::',Col2,'::',Col3) Col4 from Tb