in reply to build mysql data structure from text file

Hi FireArtist -- I'm not sure where you are headed, but seeing tab delimited data stored in a database field usually indicates a problem. (Yes, there are times it makes sense, like if you are spitting CSV data back and forth with other entities, and want to log what you sent or got in a database, sure.) If you're planning on working with the data yourself later via a DBI call followed by a spit, you might consider a better data architecture. Just a general observation --

rkg
  • Comment on Re: build mysql data structure from text file

Replies are listed 'Best First'.
Re: Re: build mysql data structure from text file
by fireartist (Chaplain) on May 13, 2003 at 22:01 UTC
    rkg, I have to build a database to recreate a printed catalogue.
    The only record of the sections (apart from DTP documents) is this text file.
    Once the structure is in the database, that's it, the database will be the sole reference for all queries etc, the text file will not be needed.
    So hopefully it won't cause any problems.
    Cheers.