Hello.
Check that MySQL doesn't hang, and that your system doesn't swap.
You can connect to MySQL server and check with 'SHOW PROCESSLIST'
states of MySQL threads. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
Juan Pablo Espino [EMAIL PROTECTED] wrote:
Hello all!
Juan Pablo Espino [EMAIL PROTECTED] wrote on 07/08/2005 03:37:14 PM:
Hello all!
I have two tables in my database: results(20 000 rows) and
data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
I need to find the samples of data_lab1 table that they are not in
results
Thanks to all,
As you says me, the solution was the indexes. I didn't have an index
in results.sample_id. Now the query returns succesfully in a few
seconds, regards
Juan P. Espino
On 7/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Juan Pablo Espino [EMAIL PROTECTED] wrote on
Hello all!
I have two tables in my database: results(20 000 rows) and
data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
I need to find the samples of data_lab1 table that they are not in
results table.
I think the following query is the solution:
SELECT
Your syntax is wrong, or at least not standard, if you are trying to do
multiple left joins.
Your ordering is not your typical for a query.
And you say there instead of where.
Your query should be structure like this:
SELECT fields
FROM table, table,...
LEFT JOIN table ON join condition
LEFT
Thanks to You Brent and Bill Easton
and Sorry
Hrmm , that what happen when not clipping direct into mail program ,
here is the Original :-) :
Select A.DepartmentName,A.Address,P.Postcode,P.cityname,CP.firstname
from caddress A,cpostinfo P
left Join CContactPerson CP , caddresscontactperson
with Left Join
From: Kim G. Pedersen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hello
the little Query1 works until I add the left join :
Query 1 )
Select A.DepartmentName,A.Address,P.Postcode,P.cityname
from caddress A,cpostinfo P
there A.ID=10 and A.PostInfoID=P.ID
Query 2)
Select
the question is.
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: Bill Easton [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 3:37 AM
Subject: Re: Problem with LEFT JOIN
OK, I'm coming back to this problem after not touching it for a while.
Sorry about
figuring out what
the question is.
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: Bill Easton [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 3:37 AM
Subject: Re: Problem with LEFT JOIN
OK, I'm coming back to this problem after not touching it for a while
this helps
Date: Sun, 19 Jan 2003 19:02:25 +0200
To: [EMAIL PROTECTED]
From: Lisi [EMAIL PROTECTED]
Subject: Problem with LEFT JOIN
I have a page with many ads that stores both the number of times an ad is
displayed and how many times it gets clicked. These are stored in two
different
clause will
then narrow the selection to the day you want.
Hope this helps
Date: Sun, 19 Jan 2003 19:02:25 +0200
To: [EMAIL PROTECTED]
From: Lisi [EMAIL PROTECTED]
Subject: Problem with LEFT JOIN
I have a page with many ads that stores both the number of times an ad is
displayed and how
I have a page with many ads that stores both the number of times an ad is
displayed and how many times it gets clicked. These are stored in two
different tables (since different information is stored for each) but both
have identical name columns. I am trying to display both # times displayed
Hi,
i've got a really strange problem with a request using multiple left join
and order by :
Here is the first sql query :
i display two columns of my table CV and one column of table ANNOTATION_CV
SELECT ID_CV,
TITRECV,ANNOTATION_CV.ANNOTATION_CV
FROM CV
LEFT JOIN CV_POSE ON
Hi, please help me with this problem...
Suppose i have a table whith ids and two more tables with logs like
this:
table0: id1,id2
table1: id1,id2,date,ip
table2: id1,id2,date,ip
Table0 is where i have all existent pairs (id1,id2).
Table1 logs all events of type 1.
table2 logs all
* ds
Hi, please help me with this problem...
Suppose i have a table whith ids and two more tables with logs like
this:
table0: id1,id2
table1: id1,id2,date,ip
table2: id1,id2,date,ip
Table0 is where i have all existent pairs (id1,id2).
Table1 logs all events of type 1.
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm trying to emulate a subselect to find non-matching values
At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote:
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm
Description:
When i want to find the next unused id from a table joining it whith another
table the result is allways 1, even though this is not correct
How-To-Repeat:
create table a (id int not null primary key);
create table b (id int not null primary key);
insert into a
Hello,
Can any of you explain me why, when i do this request :
select count(*)
from OBJET as t1 left join COLLECTION as t2
ON t1.numColl = t2.numColl
where t2.numSupp = 0;
I've got an error saying : Field numObj not found
note that numObj is the Key of table OBJET...
Thank's
--
Best
19 matches
Mail list logo