求一简单 mysql 语句 ？？

Tb:
SQL code

 Col1   Col2    Col3      AutoID
  a1     a2      a3         1
  b1     b2      b3         2
  c1     c2      c3         3

AutoID 为主健
得到的 Col4 = col1::col2::col3
得到样式：
SQL code

 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语句能实现吗？

SELECT *,CONCAT(Col1,'::',Col2,'::',Col3) AS Col4 FROM TT

SQL code

Select *,concat(Col1,'::',Col2,'::',Col3) as  Col4 
From Tb