Tab,
> On Thursday 20 March 2003 18:51, Tab Alleman wrote:
>> Still trying to get all the way through my import batch file.
>>
>> Now I'm getting a syntax error on a certain line of the file, and a
>> subsequent run produced the same exact error on the same exact line, but
>> I can't see anything wrong with that line.
>>
>> Here's the line that produces the error:
>>
>> INSERT INTO `tmphotelinfo` VALUES("yvr100058","yvr","Holiday Inn
>> Metrotown","4405 Central Blvd.","","Burnaby","BC","V5H 4M3","","(604)
>> 438-1881","(604) 438-1883","AE D MC V \r");
>>
>> Here's the error:
>>
>> ERROR 1064 at line 1036960: You have an error in your SQL syntax near
>> '"' at line 1
> It works fine for me without any error.
Are you running this from a script? Maybe it's just a script timeout
which would stop with the following line when it gets the timeout:
INSERT INTO `tmphotelinfo` VALUES("yvr100058","yvr","Holiday Inn
Metrotown","4405 Central Blvd.","","Burnaby","BC","V5H 4M3",""
For MySQL, that would simply be a syntax error.
Try to remove one line at the beginning of the dumpfile, and see if
the error occurs at the next line. If that's true, set the timeout
limit of your script higher.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
