UBBFriend: Email This Page to Someone!

DevShed Discussion Forums   MySQL   problems with load data    profile | register | preferences | faq | search

Author	Topic:   problems with load data
pnebb Junior Member	posted June 17, 2000 09:34 PM             Hi all, I am trying to import a txt file like this: AGM Alkaline Button/Coin Calcium Carbon Zinc into a table. I use this command-- load data local infile "../chemtypes2.txt" into table chemistry(chemtype); however, it only reads the top line into the chemtype column of the table--any ideas as to why? thanks for any help. regards, Patty

All times are MST (US)	next newest topic | next oldest topic
Administrative Options: Close Topic | Archive/Move | Delete Topic
	Hop to: Select a Forum List of Forums: ApacheBeginnersSecurityOpen Source DiscussionXMLWAP/WMLPostgreSQLBanner AdvertisingExchange/OutlookGraphicsHTML / DHTMLJava ServletsJavaScriptMidgardMySQLPHPPerlPythonSearch EnginesWeb HostingZope

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.