SELECT
CONCAT(
@i := CASE WHEN @pre_name = x.showName THEN @i + 1 ELSE 1 END,
"、",
x.showName) as "showName",
x.*,
(@pre_name := x.showName)
from
(select showName from table)x,
(SELECT @i := 0,@pre_customer_name := '') AS a
ORDER BY
x.company_code;
SET @rownum := 0;
SELECT
(@rownum := @rownum + 1) AS rownum,
company
FROM
t_company