safe_mysqld

2001-12-13 Thread Richard Dobson
Hi, I made a copy of safe_mysqld, ammended it and then replaced the old copy with the new one. Does anyone know why I am getting a 'no such file or directory' error when I try to execute it now? -rwxr-xr-x 1 mysqlmysql 8396 Dec 13 15:02 safe_mysqld thanks in advance Richard ___

Re: update from table x to table y

2001-11-14 Thread Richard Dobson
ey_num = Unresolved_Duplicates_perm.MinOfKey and Raw.Peak1=0; It is with this last query that there is a problem. I can do it in Access with an INNER JOIN. Hope that's clear :-) thanks Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[E

Re: update from table x to table y

2001-11-14 Thread Richard Dobson
is because they contain things such as this along with 'nested selects' and the such like. T >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PROTECTED]> >To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTEC

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
-To: "DL Neil" <[EMAIL PROTECTED]> >To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: update from table x to table y >Date: Tue, 13 Nov 2001 13:49:23 - > >Duplicating values (cf keys) in tables involves de-normalisati

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
thanks for that, but that will add a row as opposed to updating a column won't it? I don't want to insert a new row. All I want to do is update a value in table1 if it is present in table2 cheers Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Ne

update from table x to table y

2001-11-13 Thread Richard Dobson
Hi does anyone know of a way of taking some data from one table and updating another table with it? If MySQL doesn't support it i'm gonna have to go back to Access or something! thanks Rich _ Get your FREE download of MSN Explor