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...