Benjamin, any chance you can pre-process the data with an external
script prior to loading into your database?
Doing this sort of manipulation in SQL may be possible, but it surely
will be tricky. RegEx support in MySQL is present, but in my
(limited) experience with it, it's really only good fo
Hi list subscribers,
i am inserting millions of product rows from csv files via LOAD DATA INFILE.
Every product has a price, but this "price-strings" vary heavily.
The main difference between them, is the decimal format. Sometimes it is
european like this:
1.000.000,00
sometimes its american li
