RE: remote connection

on the server. Very important are hostnames. Curtis John Almberg said: I'm trying to set up a remote connection to a mysql database using Perl DBI. I have done this without problem on another database. I suspect the rights are set up differently on this one. I have root access. When I try

RE: remote connection

. Curtis John Almberg said: I'm trying to set up a remote connection to a mysql database using Perl DBI. I have done this without problem on another database. I suspect the rights are set up differently on this one. I have root access. When I try to connect, I get the following error (hostname

remote connection

I'm trying to set up a remote connection to a mysql database using Perl DBI. I have done this without problem on another database. I suspect the rights are set up differently on this one. I have root access. When I try to connect, I get the following error (hostname, username, password have been

speeding up a search

I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_id as lid from stamps as s left join links as l on (( s.item_id=l.item_id)) WHERE (s.sold is null); This worked great

Re: speeding up a search

I indexed the columns, it went down to less than a half second. KL John Almberg wrote: I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_id as lid from stamps as s left

Can't start mysql

I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains: mysqld: Can't find file: './mysql/host.frm' From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't

FW: SQL question

, September 27, 2002 9:52 AM To: John Almberg Cc: Mysql Subject: Re: SQL question ORDER BY 0 + fieldname if this is not quit right try ORDER BY 0 + fieldname , fieldname John Almberg wrote: That gives a syntax error, unfortunately. -- JOhn -Original Message- From: Mihail

RE: FW: SQL question

Yes, that works! Thank you very much! -- John -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:33 PM To: John Almberg Cc: Mysql Subject: Re: FW: SQL question John Almberg wrote: Nope. I've tried every combination I can

RE: FW: SQL question

Yes, that works! Thanks very much to all who suggested similar solutions! -- John -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:33 PM To: John Almberg Cc: Mysql Subject: Re: FW: SQL question John Almberg wrote: Nope

RE: FW: SQL question

- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:33 PM To: John Almberg Cc: Mysql Subject: Re: FW: SQL question John Almberg wrote: Nope. I've tried every combination I can think of of these ideas. They all give syntax errors. I don't think arithmatic

SQL question

I'm trying to sort a table on a character-type field that contains mostly numbers. This field always contains either a number or a number followed by a character. Like '57' or '57a'. I'd like to sort the table *numerically* on this field, not *alphabetically* on this field. That is, I'd like the