Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

2003-02-19 Thread Stephen Tiano
Stefan and Gerald-- Thanks for the input. Here's how I solved it ... I used a textfile that had worked for me the very first time I did such an exercise weeks ago. This particular textfile came on a CD with the book I was using. And by copying and pasting, so that all the spacing and line break

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

2003-02-18 Thread Stephen Tiano
Thanks to Gerald and Stefan for taking the time. Here's where I am ... Perhaps because I'm still wet behind the ears, I brainlessly included the column heads in the textfile. Of course, that's unnecessary. I substituted \N for NULL and stuck \n at the end of each line--the latter because I'm no

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

2003-02-18 Thread Stefan Hinz
Stephen, > The entries in a row are > separated by a single tab; at the end of a row, I'm hitting . I > entered twelve rows of data. The book I'm working from shows "NULL" as > some entries; and the last column, shows a timestamp in each cell of > that last column. I typed "NULL" every time my

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

2003-02-18 Thread gerald_clark
Stephen Tiano wrote: I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've create