Query fast via mysql CLI, Same query slow via Perl DBI

2004-02-13 Thread Daniel J. Conlon
Hi, When executing this query through the 'mysql' command line utility, the result is returned from the database server immediately and the database server does not create a temporary file. (SELECT domains.domain,accounts.owner,accounts.type,accounts.server,accounts.win server,zone_records.record

mysql 3.22 for solaris 2.6

2001-11-30 Thread Daniel J Nishimura
Hi, I need a version of mysql that is 3.22 or higher for solaris 2.6. On your download site, you only have support for solaris 2.5, 2.7, and 2.8. Can you help me out? Thanks. - Before posting, please check: http://www.mysql

RE: How to Run SQL Commands from a Text File stably?

2001-11-12 Thread Daniel J McDonald
se ERRORS; That would execute all of the statements that were legal, and put any errored statements in a separate file for you to clean up at your leisure. More elaborate parsing would be required if the statements were multi-line. Daniel J McDonald, CCIE 2495, CNX Principal Netwo

MYSQL on Windows 2k

2001-03-22 Thread Daniel J.
I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help.