MYSQL Limit on length of insert statements?

My tired old eyes may be failing me, but the following insert
statements look correct to me, but I can't seem to get a clean insert
from a fairly large text file database into mysql. I was wondering if
maybe I'm hitting a limit on character length per line on some insert
statements that I'm trying.

Here's the error messages:

execute failed: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near
'"COMP",5,"CRAWLSP","","PUBLIC","","LAP,STONE","","FIREPL,GR EAT- at
../res_sort.pl line 24, <> line 1.

You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '"COMP",8,"CRAWLSP","ACREADY","PUBLIC","EATAREA","WOODCOM"," ","G
at ./res_sort.pl line 24, <> line 2.

You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '"COMP",3,"CRAWLSP","ACREADY","PUBLIC","FORMAL","WOODCOM","" ,"GR
at ./res_sort.pl line 24, <> line 3.

execute failed: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near
'"COMP",3,"CRAWLSP","ACREADY","PUBLIC","FORMAL","WOODCOM","" ,"GR at
../res_sort.pl line 24, <> line 4.

Here's a sample of the insert statements (note: this is all on one
line -- though it may not appear that way because google news
automatically chops lines of greater than a certain length)

INSERT INTO
residential(ml,Area,ListPrice,City,County,Neighborhood,ZipCo de,PropertyType,LotDescription,LotDimensions,LotSize,Exterio rFeatures,NumberofLevels,InteriorFeatures,KitchenFeatures,Fi replaceDescription,ElementarySchool,MiddleSchool,HighSchool, Heat,YearBuilt,Style,NumberofBedrooms,NumberofCarGarage,Gara geDescription,NumberofFireplaces,TotalSQFT,NumberofFullBathr ooms,NumberofPartialBathrooms,TotalBathrooms,PublicRemarks,L istingAgentPublicID,ListingOfficeID,ListingOfficePhone,Listi ngAgentName,ListingAgentPhone,ListingOfficeName,Acres,Roof,N umberofPhotos,BasementFoundation,Cooling,Water,DiningRoom,Ex teriorDescription,FamilyRoom,LivingRoom,Accessibility,Virtua l,Waterfront,WaterfrontDescription)
VALUES(6003771,"44",371100,"Vancouver","Clark","Skylar
Estates",98686,"RESID","LEVEL","","5K-6,999SF","PATIO,SPRNKL R",2,"GAR-OPN,HARDWOD,TILE-FL,LAM-FL,SOAKTUB","BI-MICO,DISHW AS,DISPOSL,GASAPPL,PANTRY,FS-RANG","GAS","PLEASANT
VALLEY","PLEASANT
VALLEY","PRAIRIE","FOR-AIR",2006,"CRAFTSM",5,2,"ATTACHD",1,2 533,3,1,3.1,"Elegance
marks this home w/atrium & mother-in-law suite/office w/separate
entry.Beautiful great rm concept complete w/feplce & bamboo
hardwds.Gourmet islnd kitchn w/granite cntrtp,stlesteel appl, eating
area & formal dining. 4bedrms 3 1/2 bth.Photos/virtual tour 4 flr plan
idea only!","BREDLIES","4PLA01","360-896-5086","Shastine
Bredlie","360-904-9907","Platinum Real
Estate",,"COMP",3,"CRAWLSP","ACREADY","PUBLIC","FORMAL","WOO DCOM","","GREAT-R","","http://www.obeo.com/u.aspx?id=252119" ,"","");


Here's the record layout:

Field Type Null Key Default Extra
id int(11) PRI NULL auto_increment
ml int(11) YES NULL
Area varchar(35) YES NULL
ListPrice float(8,2) YES NULL
City varchar(30) YES NULL
County varchar(20) YES NULL
Neighborhood varchar(20) YES NULL
ZipCode int(5) YES NULL
PropertyType varchar(40) YES NULL
LotDescription varchar(18) YES NULL
LotDimensions varchar(20) YES NULL
LotSize varchar(15) YES NULL
ExteriorFeatures varchar(100) YES NULL
NumberofLevels int(1) YES NULL
InteriorFeatures varchar(100) YES NULL
KitchenFeatures varchar(100) YES NULL
FireplaceDescription varchar(10) YES NULL
ElementarySchool varchar(20) YES NULL
MiddleSchool varchar(20) YES NULL
HighSchool varchar(20) YES NULL
Heat varchar(20) YES NULL
YearBuilt int(4) YES NULL
Style varchar(10) YES NULL
NumberofBedrooms int(2) YES NULL
NumberofCarGarage int(1) YES NULL
GarageDescription varchar(10) YES NULL
NumberofFireplaces int(1) YES NULL
TotalSQFT int(5) YES NULL
NumberofFullBathrooms int(1) YES NULL
NumberofPartialBathrooms int(1) YES NULL
TotalBathrooms float(2,1) YES NULL
PublicRemarks text YES NULL
ListingAgentPublicID varchar(10) YES NULL
ListingOfficeID varchar(10) YES NULL
ListingOfficePhone varchar(13) YES NULL
ListingAgentName varchar(25) YES NULL
ListingAgentPhone varchar(13) YES NULL
ListingOfficeName varchar(25) YES NULL
Acres float(4,2) YES NULL
Roof varchar(20) YES NULL
NumberofPhotos int(1) YES NULL
BasementFoundation varchar(20) YES NULL
Cooling varchar(20) YES NULL
Water varchar(10) YES NULL
Sewer varchar(10) YES NULL
DiningRoom varchar(50) YES NULL
ExteriorDescription varchar(100) YES NULL
FamilyRoom varchar(50) YES NULL
LivingRoom varchar(50) YES NULL
Accessibility varchar(10) YES NULL
VirtualTour varchar(50) YES NULL
Waterfront varchar(10) YES NULL
WaterfrontDescription varchar(20) YES NULL

Anyone have any suggestions?

Re: MYSQL Limit on length of insert statements?

>My tired old eyes may be failing me, but the following insert
>statements look correct to me, but I can't seem to get a clean insert
>from a fairly large text file database into mysql. I was wondering if
>maybe I'm hitting a limit on character length per line on some insert
>statements that I'm trying.

I see a double comma outside of quotes appearing just before the
string listed in the error message. This is a syntax error.

>execute failed: You have an error in your SQL syntax. Check the manual
>that corresponds to your MySQL server version for the right syntax to
>use near
>'"COMP",5,"CRAWLSP","","PUBLIC","","LAP,STONE","","FIREPL,G REAT- at
>./res_sort.pl line 24, <> line 1.

Gordon L. Burditt

Re: MYSQL Limit on length of insert statements?

you should check the place with lines below...

> Bredlie","360-904-9907","Platinum Real
> Estate",,"COMP",3,"CRAWLSP","ACREADY","PUBLIC","FORMAL","WOO DCOM","","GREAT-R","","http://www.obeo.com/u.aspx?id=252119" ,"","");
~~