"1","Mac","SE30","314784","LOV","115","","","" "2","Mac","Performa6300CD","338211","LOV","109","","",""
Also, I did have all the "\" as "\N" previously.
But what about at the end of lines. What I had with "\N" wouldn't take so I was hoping someone might out what the error might be coming from by looking a few of my lines?
And to Martin: I actually, for once, DID look at the manual there before I wrote. I was really hoping someone could show me just one proper line and the syntax to upload it. :-(
Thanks, Ted
p.s. writing a script for me is not simple! ;-) I only this one with about 100 entries and I'm done, I do want to learn by it though and get it in there using some kind of text file.
On Tuesday, May 27, 2003, at 09:32 PM, Steve Gums wrote:
I know I will get ridiculed for this but you could write a rather simple awk
script to print this data comma delimited with " for strings and turn the \
into \N for MySQL and that should import rather well.
But like I said I am sure someone out there has a much better solution then
the one I mentioned.
Steve
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 7:26 PM To: MySQL List Subject: help with load from file
Hi,
I have a text file where lines look like this:
3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266 350755 LOV 003 \ 9.1 104.103
Except they are not wrapped like in this email! Each column is separated by a 'tab' (at least I think so). The "\" character represents data I don't know (null).
I have created a db and a table where I would like to upload the data; the table has 9 filelds; the data in the rows, like row 3 and row 4 above (3 & 4 is also part of the data, the record_id), are in the same order as the fields occur in the table. The table fields are setup with types and so on.
How do I get this data in there? I think I am missing somethings? (I'm trying to do it with phpMyAdmin but I can do it from CLI if someone would be so kind as to show me?)
Thank you, Ted
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
