In this case you are probably best off stripping the commas in pre-processing. If your source data file was fixed-width...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.