SQL列到字符串

In T-SQL / MS-SQL:

# With Space
SELECT ID, TEXT, 
  (1 + ' ' + 2 + ' ' + 3 + ' ' + 4 ' ' + 5 + ' ' + 6 + ' ' + 7) as Merged 
FROM blabla

# Without Space
SELECT ID, TEXT, 
  (1 + 2 + 3 + 4 + 5 + 6 + 7) as Merged 
FROM blabla

In My-SQL:

# With Space
SELECT ID, TEXT, 
  CONCAT_WS(' ', 1, 2, 3 , 4, 5, 6, 7) as Merged 
FROM blabla

# Without Space
SELECT ID, TEXT, 
  CONCAT(1, 2, 3 , 4, 5, 6, 7) as Merged 
FROM blabla

In PL-SQL/Oracle:

# With Space
SELECT ID, TEXT, 
  1 || ' ' || 2 || ' ' || 3 || ' ' || 4 || ' ' || 5 || ' ' || 6 || ' ' || 7 as Merged 
FROM blabla

# Without Space
SELECT ID, TEXT, 
  1 || 2 || 3 || 4 || 5 || 6 || 7 as Merged 
FROM blabla

在 t-sql :

Select ID, TEXT, 1 + 2 + 3 + 4 + 5 + 6 + 7 from blabla

在 PL-SQL :

Select ID, TEXT, 1 || 2 || 3 || 4 || 5 || 6 || 7 from blabla

在 MySQL :

Select ID, TEXT, CONCAT(1, 2, 3, 4, 5, 6, 7) from blabla

假设1-7是字符串字段,只需使用+字符连接字符串:

Select ID, TEXT, 1 + ' ' + 2 + ' ' + 3 + ' ' +
4 + ' ' + 5 + ' ' + 6 + ' ' + 7 as YourFieldName from blabla

我在字段之间加入了空格,但是您也可以提供逗号或其他分隔符。

如果我的理解是正确的:

从blabla中选择ID,TEXT,'1,2,3,4,5,6,7';

从blabla中选择ID、TEXT、'1'、'2'、'3'、'4'、'5'、'6'、'7';

Select ID, 
       TEXT, 
       CONCAT_WS(',', 1, 2, 3, 4, 5, 6, 7) as Concatenated
  from blabla 

或

Select ID, 
       TEXT, 
       CONCAT(1, ',', 2, ',', 3, ',', 4, ',', 5, ',', 6, ',', 7) as Concatenated
  from blabla 

在MySQL中

Select ID, 
       TEXT, 
       1 || ',' || 2 || ',' || 3 || ',' || 4 || ',' || 5 || ',' || 6 || ',' || 7) as Concatenated
  from blabla 

在甲骨文中

我认为用逗号代替加号是不可能的