你可以在php中使用money-format函数:金钱格式

You can use the function money-format in php :money-format

你可以在 mysql 中做的最接近的事情是:

The nearest you can do in mysql would be this :

SELECT *, REPLACE(REPLACE(CONCAT(FORMAT(price, 2)," €"), ",", " "),".",",") AS price FROM data