You were an excellent partner in every way. You delivered your commitments on time, you provided clear guidance on what you needed from me, why you needed it, and when my communication was not sufficient you asked for clarification.

919-341-5170

help@ideacode.com

 

Blazing a trail to better facilities management.

MySQL

MySQL CSV load-fu

Here's the setup.  I have a MySQL table of existing data and a CSV file holding new data that I want to import.  The file and database are not on the same server.  The file has not been cleaned up.  I expect this to be an ad-hoc, one off operation.

What I need is some way to put the data in the table and clean it up.  If this were to be done on a regular basis, I'd write some production code.  But since this is just some throw away code, I want to be as simple and direct as possible.  Fortunately, the MySQL LOAD DATA statement is industrial strength and can get me where I need to be.

Syndicate content