json响应mysql获取数据(json response of mysql fetch data)

 请按照以下步骤操作。 
 
 
 
 创建一个按字符长度分割数据的函数。 
CREATE FUNCTION SplitStringByLength
(   
 @inputString varchar(max),
 @length int
)
RETURNS @SplitStrings TABLE( SplitString VARCHAR(50) ) 
AS
BEGIN
  DECLARE @s VARCHAR(50)
  WHILE len(@inputString) > 0
   BEGIN
      SET @s = left(@inputString, @length)
      SET @inputString = right(@inputString, len(@inputString) - @length)
      INSERT @SplitStrings VALUES (@s)
   END
RETURN 
END
 
 
 通过将您的列和字符长度作为输入传递来调用该函数，如下所示。 
SELECT ID ,SplitString
FROM YourTable
  CROSS APPLY 
  dbo.SplitStringByLength (YourColumn,4)-- mention the character length to split
 
 
 输出：  

Follow the below steps.
 
 
 
Create a function for split your data by character length .
 
CREATE FUNCTION SplitStringByLength
(   
 @inputString varchar(max),
 @length int
)
RETURNS @SplitStrings TABLE( SplitString VARCHAR(50) ) 
AS
BEGIN
  DECLARE @s VARCHAR(50)
  WHILE len(@inputString) > 0
   BEGIN
      SET @s = left(@inputString, @length)
      SET @inputString = right(@inputString, len(@inputString) - @length)
      INSERT @SplitStrings VALUES (@s)
   END
RETURN 
END
 
 
call the function by passing your column and length of characters as input like below.
 
SELECT ID ,SplitString
FROM YourTable
  CROSS APPLY 
  dbo.SplitStringByLength (YourColumn,4)-- mention the character length to split
 
 
Output :