Issuing subqueries with while loops in Perl?

2002-03-23 Thread Patrik Birgersson
e things I sometimes need to issue another SELECT statement with variables based on one of the "sub queries", thus using another while loop within the running while loop. Is there any way that I can do this easier, without using SELECT statements in while loops? I am not a guru at th

LOAD DATA LOCAL INFILE problem with MySQL 4.0.1-alpha on RH7.3

2002-05-29 Thread Patrik Birgersson
hich looks like this: [client] port= 3306 host= localhost [safe_mysqld] open-files-limit=8192 socket=/var/lib/mysql/mysql.sock max_allowed_packet=2M Probably this .cnf file is not sufficient, but I hope that somebody might help me in the right direction :) Thn

MySQL-4.0.1-2: Bug in LOAD DATA and SOURCE statements?

2002-05-30 Thread Patrik Birgersson
s: 1 Questions: 114 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables: 20 Queries per second avg: 0.074 Note! The Client is still 4.0.1-2. Well, maybe I have missed or/and overlooked something, but maybe not... is this a bug?? Patrik Birgersson -