How to format number with “.” as thousands separator and “,” as decimal separator?

by

MySQL>=5.5:

SELECT FORMAT(10000000.5, 2, 'de_DE') AS format

MySQL<5.5:

SELECT REPLACE(REPLACE(REPLACE(FORMAT(10000000.5,2), ',', ':'), '.', ','), ':', '.') AS format

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL how to fill missing dates in range?
  4. Left Outer Join doesn’t return all rows from my left table?
  5. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  6. How to split the name string in mysql?
  7. MySQL offset infinite rows
  8. Can a foreign key reference a non-unique index?
  9. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  10. How to set a maximum execution time for a mysql query?
  11. Get the latest date from grouped MySQL data
  12. SQL keys, MUL vs PRI vs UNI
  13. How to copy a row and insert in same table with a autoincrement field in MySQL?
  14. MySQL Error 1264: out of range value for column
  15. How to change the default port of mysql from 3306 to 3360
  16. How to move columns in a MySQL table?
  17. Using group by on two fields and count in SQL
  18. Is it possible to reference one column as multiple foreign keys?
  19. Can MySQL convert a stored UTC time to local timezone?
  20. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  21. quick selection of a random row from a large table in mysql
  22. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  23. How can we find gaps in sequential numbering in MySQL?
  24. MySQL CONCAT returns NULL if any field contain NULL
  25. Does Order of Fields of Multi-Column Index in MySQL Matter
  26. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  27. Empty IN clause parameter list in MySQL
  28. How to check if field is null or empty in MySQL?
  29. mysql select id and name from other table and join query
  30. mySQL query to search all tables within a database for a string?

Leave a Comment