MYSQL Limit on length of insert statements?

[speralta]

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,"CRAW LSP","","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,"CRAW LSP","ACREADY", "PUBLIC","EATAR EA","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,"CRAW LSP","ACREADY", "PUBLIC","FORMA L","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,"CRAW LSP","ACREADY", "PUBLIC","FORMA L","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,Nei ghborhood,ZipCo de,PropertyType ,LotDescription ,LotDimensions, LotSize,Exterio rFeatures,Numbe rofLevels,Inter iorFeatures,Kit chenFeatures,Fi replaceDescript ion,ElementaryS chool,MiddleSch ool,HighSchool, Heat,YearBuilt, Style,NumberofB edrooms,Numbero fCarGarage,Gara geDescription,N umberofFireplac es,TotalSQFT,Nu mberofFullBathr ooms,NumberofPa rtialBathrooms, TotalBathrooms, PublicRemarks,L istingAgentPubl icID,ListingOff iceID,ListingOf ficePhone,Listi ngAgentName,Lis tingAgentPhone, ListingOfficeNa me,Acres,Roof,N umberofPhotos,B asementFoundati on,Cooling,Wate r,DiningRoom,Ex teriorDescripti on,FamilyRoom,L ivingRoom,Acces sibility,Virtua l,Waterfront,Wa terfrontDescrip tion)
VALUES(6003771, "44",371100,"Va ncouver","Clark ","Skylar
Estates",98686, "RESID","LEVEL" ,"","5K-6,999SF","PATIO ,SPRNKLR",2,"GA R-OPN,HARDWOD,TIL E-FL,LAM-FL,SOAKTUB","BI-MICO,DISHWAS,DI SPOSL,GASAPPL,P ANTRY,FS-RANG","GAS","PL EASANT
VALLEY","PLEASA NT
VALLEY","PRAIRI E","FOR-AIR",2006,"CRAF TSM",5,2,"ATTAC HD",1,2533,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,stlestee l appl, eating
area & formal dining. 4bedrms 3 1/2 bth.Photos/virtual tour 4 flr plan
idea only!","BREDLIE S","4PLA01","36 0-896-5086","Shastine
Bredlie","360-904-9907","Platinum Real
Estate",,"COMP" ,3,"CRAWLSP","A CREADY","PUBLIC ","FORMAL","WOO DCOM","","GREAT-R","","http://www.obeo.com/u.aspx?id=25211 9","","");
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
ExteriorFeature s varchar(100) YES NULL
NumberofLevels int(1) YES NULL
InteriorFeature s varchar(100) YES NULL
KitchenFeatures varchar(100) YES NULL
FireplaceDescri ption varchar(10) YES NULL
ElementarySchoo l 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
NumberofBedroom s int(2) YES NULL
NumberofCarGara ge int(1) YES NULL
GarageDescripti on varchar(10) YES NULL
NumberofFirepla ces int(1) YES NULL
TotalSQFT int(5) YES NULL
NumberofFullBat hrooms int(1) YES NULL
NumberofPartial Bathrooms int(1) YES NULL
TotalBathrooms float(2,1) YES NULL
PublicRemarks text YES NULL
ListingAgentPub licID varchar(10) YES NULL
ListingOfficeID varchar(10) YES NULL
ListingOfficePh one varchar(13) YES NULL
ListingAgentNam e varchar(25) YES NULL
ListingAgentPho ne varchar(13) YES NULL
ListingOfficeNa me varchar(25) YES NULL
Acres float(4,2) YES NULL
Roof varchar(20) YES NULL
NumberofPhotos int(1) YES NULL
BasementFoundat ion varchar(20) YES NULL
Cooling varchar(20) YES NULL
Water varchar(10) YES NULL
Sewer varchar(10) YES NULL
DiningRoom varchar(50) YES NULL
ExteriorDescrip tion 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
WaterfrontDescr iption varchar(20) YES NULL

Anyone have any suggestions?

[Gordon Burditt]

>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,"CRA WLSP","","PUBLI C","","LAP,STON E","","FIREPL,G REAT- at
./res_sort.pl line 24, <line 1.

Gordon L. Burditt

[ming]

you should check the place with lines below...

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

~~