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

2003-02-19 Thread Stefan Hinz
Steve, But still only one record, that first one, come in ... at least as evidenced by the SELECT * FROM [table_name]. What do I try next? Next thing is you send the CREATE TABLE statement of your table, plus at least two lines of your import text file (not as attachment, the list manager

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

Creating Tab Delimited Textfile to Load Data Into MySQL Table

2003-02-18 Thread Stephen Tiano
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 created a textfile in a text

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

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