Change decimal separator in MySQL

by

Tip for CSV exports:
SELECT REPLACE(CAST(prijs_incl AS CHAR), '.', ',') will give you input that can be used as numeric fields in european excelsheets.

More Related Contents:

  1. MySQL – Get row number on select
  2. How to use GROUP_CONCAT in a CONCAT in MySQL
  3. MySQL query / clause execution order
  4. How can I tell when a MySQL table was last updated?
  5. Operand Should Contain 1 Column – MySQL NOT IN
  6. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  7. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  8. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  9. How to use LOAD_FILE to load a file into a MySQL blob?
  10. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  11. MyIsam engine transaction support
  12. SQL Query to get column values that correspond with MAX value of another column?
  13. MySQL : transaction within a stored procedure
  14. When to use SELECT … FOR UPDATE?
  15. BULK INSERT in MYSQL
  16. Setting column values as column names in the SQL query result
  17. MYSQL sum() for distinct rows
  18. MySQL – How to search for exact word match using LIKE?
  19. Implementing a hierarchical data structure in a database
  20. MySQL date format
  21. How to get current date & time in MySQL?
  22. Laravel join with 3 Tables
  23. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  24. How do I split the output from mysqldump into smaller files?
  25. How to regex in a MySQL query
  26. How to remove duplicate entries from a mysql db?
  27. MySQL Group By Hours
  28. RMySQL dbWriteTable with field.types
  29. Syntax error on MERGE statement
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment