SQL指令的字串相加
Oracle和PostgreSQL使用符號(||)
==>Select 'Z'||lilotn as lilotn1 From Proddta.F41021
MySQL使用CONCAT(col1, col2, ...)
==>Select CONCAT('Z', lilotn) as lilotn1 From Proddta.F41021
SQL Server使用符號(&)
==>Select 'Z'&lilotn as lilotn1 From Proddta.F41021
==>Select 'Z'||lilotn as lilotn1 From Proddta.F41021
MySQL使用CONCAT(col1, col2, ...)
==>Select CONCAT('Z', lilotn) as lilotn1 From Proddta.F41021
SQL Server使用符號(&)
==>Select 'Z'&lilotn as lilotn1 From Proddta.F41021
留言
張貼留言