Mysql 3单引号一行

Question

我看到了下面的查询，用Mysql动态地将行转换为列。有人知道3个单引号在Product_Name字段之后会做什么吗？

  SET @sql = NULL;
   SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'count(case when Product_Name = ''',
      Product_Name,
      ''' then 1 end) AS ',
      replace(Product_Name, ' ', '')
    )
  ) INTO @sql
from products;

SET @sql = CONCAT('SELECT pt.partner_name, ', @sql, ' from partners pt
left join sales s
  on pt.part_id = s.partner_id
left join products pd
  on s.product_id = pd.prod_id
group by pt.partner_name');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Answer 1

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html说：

以'引号引用的字符串中的'可以编写为''。

那页手册上有很多例子。