load data infile
I have a strange problem importing data from a text file. There are 1353 rows in the text file (generated by a Perl script) but only 1000 get imported into MySQL. I am clueless why would this be happening - it seems as if there was a cutoff point at 1000 rows which, of course, doesn't make any sense. Any thoughts much appreciated. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perl arrays into MySQL
This may be a silly question, but I am wondering if there is something opposite to: @row = $sth-fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite - take a Perl (associative) array and load it into MySQL table. I know I could dump it into a text file and read it from there, but assuming I do not want to go through this intermediary step, how could I do it? Any suggestions appreciated. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reading MS Access tables from MySQL or Perl
Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and load them into MySQL. It would be run at a click of a button from a web interface to display updated MySQL tables. However, after few hours of googling it appears that this is easier said than done due to ODBC and DSN quirks. Direct import into MySQL requires external utility like DBTools which defeats desired automation of the procedure. Is there a known best way to do this and has anyone done something similar? Thanks in advance for any hints. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reading MS Access tables from MySQL or Perl
Thanks for that tip. It helped me find a page which explains it properly. In case anyone else might be interested, here is the link. http://www.awilcox.com/geek_stuff/perl/proxy.html -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
load strips first character
Hello, I am loading data from a text file where filed3 is a path to a document in a format \\path\to\some\directory but after loading into MySQL it appears as \path\to\some\directory with the first backslash stripped away. Why is this happening and how can I avoid it? LOAD DATA INFILE '/local/datadocument.txt' INTO TABLE tdocument FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, field2, field3); Thanks, -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
inserting values from another table
Hello, I just subscribed to the list (after a few years of absence) and have a rather basic question - I have two tables table1 and table2: table1 - primarykey1, foreignkey, somevalue table2 - primarykey2, somevalue Both tables are populated with records, but foreignkey in table1 has no value. I want to copy primarykey2 from table2 into foreignkey in table1 for records where table1.somevalue=table2.somevalue If my understanding is correct, this should be straightforward with v4.1 where multitable UPDATE is supported, but since I am using 3.23.52 I think a different approach is required. If anyone can suggest a workaround, I would greatly appreciate it as I am not really an expert in this area. Thanks in advance. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slow MySQLGUI
I had similar experience with MySQL GUI although my connection is over 1.5Mbs ADSL. If I use MySQL WinAdmin the response is instantaneous. I know that applications with ported Unix interfaces can be slightly sluggish, but not 20-30 seconds - so it has to be something else. My client is W2K and web host MySQL/Debian Linux. I'd be curious to know if there is anything in the communication pipeline that could be potentially accountable for this speed difference? Nik Belajcic Sydney. - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 29, 2001 9:37 PM Subject: Re: slow MySQLGUI MySQLGUI uses native interface, while Access uses ODBC interface and mysqlgui should be several times faster over slow lines. This could be simply a chance that when you used mysqlgui lines were slow. To accelerate things, turn on use of compression on mysqlgui in Options dialogue and save it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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