473,231 Members | 2,009 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

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,GREAT- 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","W OODCOM","","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","W OODCOM","","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,Neighbor hood,ZipCode,PropertyType,LotDescription,LotDimens ions,LotSize,ExteriorFeatures,NumberofLevels,Inter iorFeatures,KitchenFeatures,FireplaceDescription,E lementarySchool,MiddleSchool,HighSchool,Heat,YearB uilt,Style,NumberofBedrooms,NumberofCarGarage,Gara geDescription,NumberofFireplaces,TotalSQFT,Numbero fFullBathrooms,NumberofPartialBathrooms,TotalBathr ooms,PublicRemarks,ListingAgentPublicID,ListingOff iceID,ListingOfficePhone,ListingAgentName,ListingA gentPhone,ListingOfficeName,Acres,Roof,NumberofPho tos,BasementFoundation,Cooling,Water,DiningRoom,Ex teriorDescription,FamilyRoom,LivingRoom,Accessibil ity,Virtual,Waterfront,WaterfrontDescription)
VALUES(6003771,"44",371100,"Vancouver","Clark","Sk ylar
Estates",98686,"RESID","LEVEL","","5K-6,999SF","PATIO,SPRNKLR",2,"GAR-OPN,HARDWOD,TILE-FL,LAM-FL,SOAKTUB","BI-MICO,DISHWAS,DISPOSL,GASAPPL,PANTRY,FS-RANG","GAS","PLEASANT
VALLEY","PLEASANT
VALLEY","PRAIRIE","FOR-AIR",2006,"CRAFTSM",5,2,"ATTACHD",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,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","FO RMAL","WOODCOM","","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?

Jul 17 '06 #1
2 8232
>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,GREAT- at
./res_sort.pl line 24, <line 1.
Gordon L. Burditt
Jul 18 '06 #2

you should check the place with lines below...
Bredlie","360-904-9907","Platinum Real
Estate",,"COMP",3,"CRAWLSP","ACREADY","PUBLIC","FO RMAL","WOODCOM","","GREAT-R","","http://www.obeo.com/u.aspx?id=252119","","");
~~

Jul 18 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: duikboot | last post by:
Hi all, I'm trying to export a view tables from a Oracle database to a Mysql database. I create insert statements (they look alright), but it all goes wrong when I try to execute them in Mysql,...
0
by: Lenz Grimmer | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary...
0
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
1
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...
7
by: greywire | last post by:
So I need to load lots of data into my database. So I discover LOAD DATA INFILE. Great! This little gem loads my CSV in blazing times (compared to parsing the file and doing INSERT for each...
1
by: Ike | last post by:
Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The following query used to work: select firstname,...
2
by: newbie | last post by:
Dear folks, pardon me if this is a stupid question. For this table --------------------------------------- | id | foo | bar | -------------------------------------- I...
6
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
1
ssnaik84
by: ssnaik84 | last post by:
Hi Guys, Last year I got a chance to work with R&D team, which was working on DB scripts conversion.. Though there is migration tool available, it converts only tables and constraints.. Rest of...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.