Text qualifiers
Hi everyone... Long time listener, first time caller. Actually I'm a first time everything. Be gentle. I have an slew of Access DBs that I need to port some of the info into a MySQL DB. I guess my main problem is my I have no idea in what format to export my data from the Access DB. In general I export it as a tab delimited file with no text qualifiers. Unfortunately, much of the data has a carriage return as part of the data. The carriage returns terminate the line and my import fails. I tried to wrap the text in double quotes to tell it not to terminate the line. However, my imports have still failed. This could be due to my lack of experience or wrong syntax. But I did everything as told in the documntations. Any ideas? Won Lee - 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
RE: Text qualifiers
LOAD DATA LOCAL INFILE 'C:/Documents and Settings/won/My Documents/summary.txt' INTO TABLE spacedx.summary FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (groupID,structural,mechanical,electrical,safety,vertical,misc)\ I'll save the trouble of cutting and pasting the output because it's really long. The carriage return in all the fields except groupID causes the line to terminate and I get about 6 times as many INSERTS than it should be. -Original Message- From: Christopher Book [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 4:31 PM To: '[EMAIL PROTECTED]' Subject: Text qualifiers >I tried to wrap the text in double quotes to tell it not to terminate the line. However, my imports have still failed. This could be due to my lack of experience or wrong syntax. But I did everything as told in the documntations. What parameters are you using for your import? If you give us a sample output record and your input command people here can usually find the problem. Chris table, sql, query - 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
ERD
Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. Won = Not being a materialist in the U.S. is kind of like not appreciating opera if you live in Milan or art if you live in Paris. We support materialism better than any other culture. Because retailing and distribution are so efficient here, stuff is cheaper than anywhere else in the world. And then we have huge houses in which to archive our stuff. - 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
news group
Is this MySQL mailing list available via a news group? Won - 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
