On a brighter note, I just ordered your 3rd edition of "MySQL." You are an
excellent author.
~mark
>>> Paul DuBois <[EMAIL PROTECTED]> 11-May-06 11:11:44 AM >>>
On 5/11/06 10:06, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:
> Oh SHIT! I had the text files in the wrong directory. It works now. I am so
> DUMB!
Ah, well. Join the club. :-)
>
> Thank you all for all the suggestions and time you spent on my non-problem. I
> wish the error message would have been a little more instructive, however.
>
> mark
>
>>>> Paul DuBois <[EMAIL PROTECTED]> 11-May-06 11:01:14 AM >>>
> Huh. And you say this worked before? I don't see how it could.
>
> $table is an identifier and shouldn't be surrounded by single quotes. That
> particular name doesn't need any quoting, but if it did, the quote character
> should be backtick (`), not apostrophe (').
>
> Also, you might need to say \\n rather than \n, or perhaps even \\\\n
> to compensate for both Perl and MySQL stripping escape characters. But that
> wouldn't result in the syntax error you're seeing, it would just make the
> statement not parse data correctly.
>
> Your statement uses $datafile, but you report the value of $filename... typo
> in your message?
>
>
> On 5/11/06 9:30, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:
>
>> There is no error in the log file. The actual terminal print is:
>>
>> %> import_dbf.pl: DBD::mysql::db do failed: You have an error in your SQL
>> syntax; check the manual that corresponds to your MySQL version for the right
>> syntax to use near 'MRJE001' FIELDS TERMINATED BY '|' LINES TERMINATED BY '
>>
>> The actual code is:
>>
>> $rows = $dbh->do("LOAD DATA INFILE '$datafile' IGNORE INTO TABLE '$table'
>> FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'");
>>
>> $filename = mrje001.txt
>> $table = MRJE001
>>
>> Just is correct. There must be a bug in DBD::mysql(3)
>>
>> ~mark
>>
>>>>> Paul DuBois <[EMAIL PROTECTED]> 11-May-06 09:29:20 AM >>>
>>
>> Check the server's query log to see what statement actually is arriving on
>> the server side.
>>
>> Also, you say you get a malformed SQL syntax error. What's the exact
>> message you get?
>>
>>
>> On 5/11/06 8:02, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:
>>
>>> Tim,
>>>
>>> I've tried every imaginable option: single quotes, double quotes, escaped
>>> quotes, table name only, no quotes....nothing works. I think there is a bug
>>> in DBD::mysql(3). I have spent hours and hours googling this problem and no
>>> one else has reported it.
>>>
>>> ~mark
>>>
>>>>>> Tim Bunce <[EMAIL PROTECTED]> 11-May-06 08:40:24 AM >>>
>>> On Wed, May 10, 2006 at 09:26:52AM -0400, Mark Galbreath wrote:
>>>> Of course it's a string. It was a typo.
>>>>
>>>> my $rows = $dbh->do("LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table'
>>>> FIELDS
>>>> TERMINATED BY '|'");
>>>>
>>>> 'db.table' == "database_name.table_name"
>>>
>>> Don't put single quotes around the table name.
>>>
>>> db.table
>>> or `db`.`table`
>>>
>>> should work, but 'db.table' won't.
>>>
>>> Tim.
>>>
>>>>>>> Paul DuBois <[EMAIL PROTECTED]> 10-May-06 09:13:47 AM >>>
>>>>
>>>> On 5/10/06 7:58, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:
>>>>
>>>>> Hi guys,
>>>>>
>>>>> The following query works fine from the MySQL client:
>>>>>
>>>>> LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY
>>>>> '|'
>>>>>
>>>>> but fails in perl with a malformed SQL syntax error:
>>>>>
>>>>> my $rows = $dbh->do(LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table'
>>>>> FIELDS
>>>>> TERMINATED BY '|');
>>>>>
>>>>> Anybody have a clue as to why this will not work?
>>>>
>>>> That hasn't the faintest hope of working. You should post the actual code
>>>> that you're using. do() with a non-string argument is surely not your
>>>> actual code.
>>>>
>>>> Also, 'db.table' doesn't look like a valid quoted identifier.
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>>
>>
>
>
>
