I just ran your query (create and both inserts), and it worked like a charm
on a Win32 MySQL 3.23.52.
Just out of curiousity, why are putting the \r in?
----- Original Message -----
From: "Tab Alleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 20, 2003 10:51 AM
Subject: Import Batch syntax error
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
Here's the previous line, which apparently doesn't cause an error:
INSERT INTO `tmphotelinfo` VALUES("yvr100057","yvr","Holiday Inn Hotel &
Suites","1110 Howe Street","","Vancouver","BC","V6Z 1R2","","(604)
684-2151","(604) 684-4736","AE D MC V \r");
I see no appreciable difference between the lines.
Here's the line which creates the tmphotelinfo table:
CREATE TABLE `tmphotelinfo` (
`OrgID` varchar(9) default NULL,
`MetroCode` char(3) default NULL,
`Name` varchar(100) default NULL,
`Address1` varchar(100) default NULL,
`Address2` varchar(100) default NULL,
`City` varchar(50) default NULL,
`State` varchar(10) default NULL,
`Zip` varchar(16) default NULL,
`Country` varchar(50) default NULL,
`Phone` varchar(24) default NULL,
`Fax` varchar(24) default NULL,
`CCs` varchar(32) default NULL,
KEY `OrgID` (`OrgID`)
) TYPE=MyISAM;
...and finally, there's nothing in the mysql.err file to give me a
further clue. Does anybody here see something I don't?
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
