I have a txt file which gets issued periodically. It's tab separated and I'd like to automate getting that data into my database as efficiently as possible. I'm new to MySql but experience says that I'm not going to be the first to have this issue.
I feel like I should be able to import a table using code (not a workbench), but I can't find that solution. Is updating 40k lines one by one my only solution?