Showing entries 1 to 1
Displaying posts with tag: text file (reset)
Load columnar text file into MySQL table

Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table looks something like this: Company1 Street Name City, MyState 8582 (999)999-999 another_Company Another Street 2 New City, NWSTATE 8582 (111)111-1111 So how’d you go about loading a text file into MySQL where field values are given in a single column!! In the above sample, data has fields like company-name, address-1, address-2 and phone given in a text file line by line. Ofcourse you can write a piece of code in...

The post Load columnar text file into MySQL table first appeared on ..::CHANGE is INEVITABLE::...

Showing entries 1 to 1