Re: [PHP] From TXT to a mySQL db

On Oct 18, 2007, at 3:15 PM, Marcelo Wolfgang wrote: This looks good, but since the db server is in a hosting company it will be possible to read from a .txt ? also I have never seen the LOAD DATA command, so I'm testing here and having problems ... can anyone spot what's wrong on this que

Re: [PHP] From TXT to a mySQL db

Hi. On Thursday 18 October 2007 19:29, Marcelo Wolfgang wrote: > Hi all, > > I need some helps/tips to know if a transition from a txt file to a sql > database is viable to do. [snipped data and table descriptions] > Is there a quick and simple way to convert the row string into a INSERT > query

Re: [PHP] From TXT to a mySQL db

This looks good, but since the db server is in a hosting company it will be possible to read from a .txt ? also I have never seen the LOAD DATA command, so I'm testing here and having problems ... can anyone spot what's wrong on this query ? $SQL = "LOAD DATA INFILE 'test.txt' INTO TABLE test

Re: [PHP] From TXT to a mySQL db

On Oct 18, 2007, at 2:29 PM, Marcelo Wolfgang wrote: Hi all, I need some helps/tips to know if a transition from a txt file to a sql database is viable to do. I have a TXT file that has lots of records like this: 10^13150^COMERCIO DE CALCADOS DILEU LTDA^COMERCIO DE CALCADOS DILEU LTDA^R