In this case you are probably best off stripping the commas in pre-processing. If your source data file was fixed-width you could also perform a LOAD DATA without specifying column separators and MySQL would read the fixed-width file.
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.