What queries, precisely, I can't tell you, but you can have a good idea
about how your cache performs using the stuff in "show global variables;"
and the online manuals about what it all means :)
Look at 'show global variables like %qcache%', for a start.
On Fri, May 7, 2010 at 2:22 PM, Darvin De
Can somebody help me with this?
Thanks!
On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian
wrote:
> Hello,
>
> I've activated the query_cache in Mysql with the variable
> "query_cache_limit" value to 1 MB.
> My question is:
>
> How to know what queries wasn't cached because they have exceeded the
>
Hello,
I've activated the query_cache in Mysql with the variable
"query_cache_limit" value to 1 MB.
My question is:
How to know what queries wasn't cached because they have exceeded the
value of "query_cache_limit"?
**Sorry for my Brazilian Englihs :(
Thanks!
--
MySQL General Mailing List
For
s.
> > >
> > > And i need i clean on item_instance how this query:
> > >
> > > DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
> > > `character_inventory`) AND guid NOT IN(SELECT item_guid FROM
> > > `guild_bank_item`) AND guid NOT
> Sent: Thursday, January 14, 2010 11:00 PM
> To: Junior Ortis
> Cc: mysql@lists.mysql.com
> Subject: Re: Better that `NOT IN`
>
> For alternatives, have a look at "The unbearable slowness of IN()" at
> http://www.artfulsoftware.com/queries.php.
>
> PB
On 1/15/10 12:01 AM, "Junior Ortis" wrote:
> Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
> character_inventory 15KK rows, guild_bank_item 2KK rows.
>
> And i need i clean on item_instance how this query:
>
> DELETE FROM `item_instance` W
i clean on item_instance how this query:
DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
`character_inventory`) AND guid NOT IN(SELECT item_guid FROM
`guild_bank_item`) AND
guid NOT IN(SELECT item_guid FROM `mail_items`) and guid NOT IN(SELECT
itemguid FROM `auctionhouse`);
W
Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
character_inventory 15KK rows, guild_bank_item 2KK rows.
And i need i clean on item_instance how this query:
DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
`character_inventory`) AND guid NOT IN(SELECT
Hi there,
I have a list of events that occur periodically:
1/1/2008Event
1/1/2008Event
1/1/2008Event
1/2/2008Event
1/2/2008Event
1/4/2008Event
1/4/2008Event
I know how to count events per day, but on
`
What I need is query that will give me a list of names that are in the
Q2 result but not in the Q1 result. This is easy enough if I am just
doing the match on one filed I can do this
SELECT Name
FROM
namelist
WHERE `Date` AND Name NOT IN(
SELECT Name
FROM . . . . . . )
What I can't figure o
will give me a list of names that are in the
Q2 result but not in the Q1 result.
This is easy enough if I am just doing the match on one filed I can do this
SELECT Name
FROM
namelist
WHERE `Date` AND Name NOT IN(
SELECT Name
FROM . . . . . . )
What I can't figure out is how to do it if I wa
20, 2006 1:53 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: help with query: select customers that ARO NOT
in orders table
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
hi to all,
I have table customers (PK cust_id)
I have table orders (PK order_id, FK cust_id)
I need query t
, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Waldemar Jankowski [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 20, 2006 1:53 PM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: help with query: select customers that ARO NOT
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
Ok. Just found I gave wrong info. To make my life easier, the person who
created db named cust_id in 'orders' table as SoldTo
[EMAIL PROTECTED]
in this case,
select cust_id from customers
where cust_id not in
(select Soldto from orde
Ok. Just found I gave wrong info. To make my life easier, the person who
created db named cust_id in 'orders' table as SoldTo
[EMAIL PROTECTED]
in this case,
select cust_id from customers
where cust_id not in
(select Soldto from orders);
will not work
:(
> On Fri, 20 Oct
.
couls somebody help me?
thanks.
-afan
I think the most explicit way is with a sub select:
select cust_id from customers where
cust_id not in
(select cust_id from orders);
-w
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
hi to all,
I have table customers (PK cust_id)
I have table orders (PK order_id, FK cust_id)
I need query that will selecct all customers from 'customers' they don't
have any order, there is not their cust_id in 'orders'.
couls somebody help me?
thanks.
-afan
--
MySQL General Mailing List
For
2006 6:05 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm
, 2006 6:43 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:30 am, Peter Lauri wrote:
> 4.0.27, so that is probably the reason. Any other way then with a sub
> query? I solved it with my "stupid" solution, feels strange to J
On Wednesday 26 July 2006 11:30 am, Peter Lauri wrote:
> 4.0.27, so that is probably the reason. Any other way then with a sub
> query? I solved it with my "stupid" solution, feels strange to JOIN tables
> and choose rows where the join value is NULL (left outer join) :)
Are you using phpMyAdmin?
: Thursday, July 27, 2006 6:05 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
> The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
> The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here
and that works just fine.
--
Chris White
PHP Programmer/DBackItUp
Interfuel
--
MySQL Gener
The query in full was exactly as you wrote it (but without the typo) :)
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 5:56 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July
On Wednesday 26 July 2006 10:53 am, Peter Lauri wrote:
> I tried that, but that generates:
>
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'SELECT id FROM table2)
> LIMIT 0, 100' at line 1
What's
upport sub queries?
/Peter
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 5:37 AM
To: mysql@lists.mysql.com
Subject: Re: JOIN table where not in other table
On Wednesday 26 July 2006 10:31 am, Peter Lauri wrote:
> Best group member,
>
>
FROM table 1
WHERE id NOT IN
(SELECT id FROM table2);
--
Chris White
PHP Programmer/DBacardi
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best group member,
I just made up this query, but let us work from this:
SELECT * FROM table1
LEFT OUTER JOIN table2 ON (table1.id=table2.id)
WHERE table2.prop IS NULL;
This selects all rows from table1 where the id is not also in the table2. Is
there any more logic way to do this, this is what
[EMAIL PROTECTED] wrote:
>I want to select a list, where it was registered in tbl
club_get_match with Id-
>Member in tbl detail_club_member, but it's not registered in tbl
wager.
Your schema has a problem: wagers.name_club is too short. If no
club_get_match.name_club value is longer than 20 c
CREATE TABLE `club_get_match` (
`id_match` bigint(100) NOT NULL default '0',
`name_club` varchar(30) NOT NULL default '',
`status` varchar(30) default NULL,
`prediction_match` varchar(5) NOT NULL default '',
`equal_match` char(3) NOT NULL default '',
`score` varchar(50) default NULL,
[EMAIL PROTECTED] wrote:
Sory if my question makes you confused
I've a problem with my sintax,
I don't know how to select a list, whether it's not registered in another
table, but it have 2 IDs.
Not enough info. Show the Create Table statements, a bit of data, and
the desired result.
PB
I
Sory if my question makes you confused
I've a problem with my sintax,
I don't know how to select a list, whether it's not registered in another
table, but it have 2 IDs.
I hope you will help me because I really need it for my study.
Thank you in advance,
regards,
Eva Panjaitan
11104029
Stu
Uh, I don't have anything to add to this thread except that this was
the *exact* problem I was trying to solve and this really helped me a
lot. Thanks guys.
-BL
On 5/22/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Hi,
>
> Greatly appreciated your kind help. Would it wor
T * FROM t3;
++
| id |
++
| 3 |
| 5 |
| 7 |
| 9 |
| 11 |
++
5 rows in set (0.00 sec)
Hope this answers your questions!
Cheers,
-jay
Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of
cu
ON c.company_id = cu.company_id
WHERE p.company_id IS NULL
AND cu.company_id IS NULL;
I am not sure if this join query will remove records from other tables.
Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Dear All,
>
> Need to find ids that are NOT in ot
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP
scripting and three queries I am able to do the task. Can this be done with
one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT company_id FROM
At 18:28 -0400 5/11/06, Fan, Wellington wrote:
Hello all,
I have inherited this query:
SELECT
events.eventID AS id,
attribute_master.attributeID AS attrib_id
FROM
events,
attribute_master
WHERE
events.status='8' AND
events.eventReview!='' AND
Hello all,
I have inherited this query:
SELECT
events.eventID AS id,
attribute_master.attributeID AS attrib_id
FROM
events,
attribute_master
WHERE
events.status='8' AND
events.eventReview!='' AND
events.modlast > 1146470445 AND
event
gerald_clark wrote:
I've checked the archives and found an explanation as to how the
check if a record is not in a many-to-many table. The answer to
that is somewhat simple and clear to me. But here's my problem: how
do you check if a record doesn't have a *particula
I've checked the archives and found an explanation as to how the
check if a record is not in a many-to-many table. The answer to that
is somewhat simple and clear to me. But here's my problem: how do
you check if a record doesn't have a *particular* many-to-many
relat
Marco,
I've checked the archives and found an explanation as to how the check
if a record is not in a many-to-many table. The answer to that is
somewhat simple and clear to me. But here's my problem: how do you
check if a record doesn't have a *particular* many-to-many
relat
Hey all,
I've checked the archives and found an explanation as to how the check
if a record is not in a many-to-many table. The answer to that is
somewhat simple and clear to me. But here's my problem: how do you
check if a record doesn't have a *particular* many-to-many
re
Your question seems to have been answered already, so let me add one
cautionary note -- use a LIMIT clause when testing out a new query!
Especially with a join. A simple mistake can lead to a Cartesian
product of 2 tables -- I always do limit 100 or something so that I
can then check to see that
Obviously you can do a join when the names of id columns are different as
well. Look in the doc for that. This has nothing to do with your problem of
finding rows not in another table - it is a basic sql thing.
Stefan
Am Sunday 26 March 2006 00:47 schrieb barney:
> Thanks, Stefan,
>
>
I wish!
That's the first thing that occurred to me ... unfortunately, this must be done
by query ... I'm not allowed to create tables . Seems the guy I'm
doin' this for doesn't trust me that far ... he got burned pretty badly a few
years ago by a developer building in back-door access to his s
barney wrote:
Thanks, Stefan,
But that only works if both tables have the same field name, doesn't it? If I
use select FileKey from dl_files left join dl_merges using (FileID) where
FileID is null MySQL returns
Unknown column 'articles.dl_files.FileID' in 'on clause'.
Correct me if I'm wrong,
barney
Correct me if I'm wrong, but wouldn't I have to modify the column name
in one of the tables in order for that to work? Or is there a syntax
in the join lexicon that I can use to alias one of the column names
within the query? I can't modify the existing table structure(s).
If the jo
Thanks, Stefan,
But that only works if both tables have the same field name, doesn't it? If I
use
select FileKey from dl_files left join dl_merges using (FileID) where FileID is
null
MySQL returns
Unknown column 'articles.dl_files.FileID' in 'on clause'.
Correct me if I'm wrong, but wouldn't I
Use
select first_table.id from first_table left join second_table using (id) where
second_table.id is null
Stefan
Am Saturday 25 March 2006 19:10 schrieb barney:
> Folk,
>
> This may be off-base for this list, but I've run out of places to look,
> sorry. I can't seem to find this anywhere, al
Folk,
This may be off-base for this list, but I've run out of places to look, sorry.
I can't seem to find this anywhere, although I'm certain I've seen it before.
How can I identify all the records in a table that are not referenced in a
many-to-many table?
I have a [unique] table of files an
Bob,
There's some discussion of it at
http://dev.mysql.com/doc/refman/5.0/en/rewriting-subqueries.html.
PB
-
Bob Gailer wrote:
Michael Stassen wrote:
Bob Gailer wrote:
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the
product_table, >but
Michael Stassen wrote:
Bob Gailer wrote:
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The
product_table >has all the products, but the sale table is a subset
of the prod
Thanks,
This worked exactly like I had hoped.
Grant
Peter Brawley <[EMAIL PROTECTED]> wrote:Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but
Bob,
>> SELECT * FROM product_table p
>>LEFT JOIN sale_table s USING (prod_id)
>>WHERE s.prod_id IS NULL;
>I have not tested that but I don't think it will work. Try:
>SELECT item_name
>FROM product_table
>WHERE prod_id not in (select prod_id from sale_table
Bob Gailer wrote:
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the
product_table.
SELECT * FROM prod
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the product_table.
SELECT * FROM product_table p
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the product_table.
SELECT * FROM product_table p
LEFT JOIN sale_table s USING
Hi,
I have 2 tables like:
product_table:
prod_id
item_name
price
data
data
etc
sale_table:
prod_id
sale_price
If I want to select all the products that are in the product_table, but not in
the sale_table, how to make the query? The product_table has all the products,
but the sale table is
Shawn,
I've just found out that most of my emails during this discussion were
NOT posted to the list because I was sending mail in HTML format and
Yahoo was not delivering the bounce notices to me. That explains why you
believed I was not listening to Peter's input - only _his_ messages were
---+---++-------+-
> +-+---+-
> ++
>
>
&
nct |
++-+---++---+-+-+---+-++
d1 mysql> explain SELECT offer_id FROM paytable WHERE login_id=1 AND
offer_id NOT IN ( SELECT offer_id FROM offers LEFT JOIN
publisher_advertiser_blocks AS pab
[EMAIL PROTECTED]> wrote on 02/01/2006 12:25:01
AM:
> Devananda,
>
> >Definitely not. The first LEFT JOIN, with the clauses
> >"ON pt.login_id=pab1.login_id ... WHERE pab1.login_id IS NULL",
> > does not make sense.
>
> ?!? It's a standard JOIN
Devananda,
>Definitely not. The first LEFT JOIN, with the clauses
>"ON
pt.login_id=pab1.login_id ... WHERE pab1.login_id IS NULL",
> does not
make sense.
?!? It's a standard JOIN replacement for NOT IN (...).
>There is not a 1to1 relationship,
These joins
Devananda,
OK, get the diescription in ordinary language right, and the query
ought to write itself. Your schema is like this? ...
and you want the paytable rows
(i) for which there is an offers row matching paytable.offer_id, and
(ii) for which there is no pab row where
pab.login_
m crowding the screen.
The two queries have about the same execution time but very different
EXPLAIN results... without further ado, here they are:
explain
select count(*) from paytable
where login_id=#
and offer_id NOT IN
(
select distinct offer_id
from that
offer_id. While testing I simply selected count(*) to keep my result set
from crowding the screen.
The two queries have about the same execution time but very different
EXPLAIN results... without further ado, here they are:
explain
select count(*) from paytable
where
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/12/2006 12:47:31
AM:
> On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006
11:33:38
> > PM:
> >
> > > I have three tables joined on key fields: delivery is joined
Hi,
2006/1/12, Vincente Aggrippino <[EMAIL PROTECTED]>:
> On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> That fixed it... Thank you! But I don't understand how. Isn't my implicit
> inner join the same as the explicit one you used?
>
> I read Join Syntax in the ref. manual. Is it
On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38
> PM:
>
> > I have three tables joined on key fields: delivery is joined with
> > invoice_detail on delivery_id and with location on loc_id. I want to
> return
> >
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38
PM:
> I have three tables joined on key fields: delivery is joined with
> invoice_detail on delivery_id and with location on loc_id. I want to
return
> records of deliveries that have corresponding records in the location
tab
I have three tables joined on key fields: delivery is joined with
invoice_detail on delivery_id and with location on loc_id. I want to return
records of deliveries that have corresponding records in the location table,
but have no corresponding records in the invoice table.
Here's the query I'm a
Ooops, it would help if I put in the error message
Configuration: mysql - Win32 Debug
Linking...
mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symbol
_my_access
../client_debug/mysql.exe : fatal error LNK1120: 1 unresolved externals
E
Having trouble building 5.0.x, 4.1.12 builds fine
The very first program to link bombs, I'm thinking some dll is not
registered, or a change in build directions between 4.1.x and 5.0.x the
error is less than helpful, as I'm a dba not a programmer.
Any sugestions? I can build 5.0.3, but not 5.
lcount, itemname from viewvisitor where ownerid =
2 GROUP BY concat( app, itemid ) ORDER BY totalcount;
Rich Carr wrote:
>Is there a way to set which rows values are used by the GROUP BY clause for
>the fields that are not in the GROUP BY clause?
>
>In this following select statement the
BY clause for the
fields that are not in the GROUP BY clause?
In this following select statement the group by and order work but the value of the lastviewtime field is not the value of the most recent datetime row. Is there any way to modify the select statement so that the returned lastviewtime
|
>+--++--+
>
>or GROUP_ROW(cols,sortby=)
>
>-- More sillyness
>SELECT id, group_row(child_id,type,sortby=rand())
>FROM chi2 GROUP BY id;
>
>Just an idea.
>
>Dan.
>
>On Mon, 11 Apr 2005, Rich Carr wrote:
>
>>Is there a way to set which ro
t;+--++--+
>| 1 | 1 | 0 |
>| 5 | 2 | 2 |
>+--++--+
>
>or GROUP_ROW(cols,sortby=)
>
>-- More sillyness
>SELECT id, group_row(child_id,type,sortby=rand())
>FROM chi2 GROUP BY id;
>
>Just an idea.
>
>Dan.
>
>On Mon, 11 Apr
id, group_row(child_id,type,sortby=rand())
FROM chi2 GROUP BY id;
Just an idea.
Dan.
On Mon, 11 Apr 2005, Rich Carr wrote:
>Is there a way to set which rows values are used by the GROUP BY clause
>for the fields that are not in the GROUP BY clause?
> In this following select statement
Is there a way to set which rows values are used by the GROUP BY clause for the
fields that are not in the GROUP BY clause?
In this following select statement the group by and order work but the value of
the lastviewtime field is not the value of the most recent datetime row. Is
there any
Peter Brawley wrote:
Giuseppe,
>mysql> select 2 not in (1,null,3);
>+-+
>| 2 not in (1,null,3) |
>+-+
>|NULL |
>+-+
>1 row in set (0.00 sec)
># NOT OK
Isn't that standard SQL b
Giuseppe,
>mysql> select 2 not in (1,null,3);
>+-----+
>| 2 not in (1,null,3) |
>+-+
>|NULL |
>+-+
>1 row in set (0.00 sec)
># NOT OK
Isn't that standard SQL behaviour? NULL is not a value. N
In article <[EMAIL PROTECTED]>,
Giuseppe Maxia <[EMAIL PROTECTED]> writes:
> The whole point is actually in subqueries, not when using IN or NOT IN in a
> normal query.
> The bug occurs when a NOT IN is used in a subquery as a LEFT JOIN replacement.
> SELECT something f
Dan Nelson wrote:
In the last episode (Mar 16), Giuseppe Maxia said:
Here is a description of what looks like a serious bug. This is
related to bugs #7294 and #6247
Tested against mysql 4.1.9 and 4.1.10.
Description:
operator NOT IN fails when a subquery returns one or more NULL
values.
How
In the last episode (Mar 16), Giuseppe Maxia said:
> Here is a description of what looks like a serious bug. This is
> related to bugs #7294 and #6247
>
> Tested against mysql 4.1.9 and 4.1.10.
>
> >Description:
> operator NOT IN fails when a subquery
Hi.
Here is a description of what looks like a serious bug.
This is related to bugs #7294 and #6247
Tested against mysql 4.1.9 and 4.1.10.
Cheers
Giuseppe Maxia
>Description:
operator NOT IN fails when a subquery returns one or more NULL values.
>How-To-Repeat:
simple pr
SQL: SELECT scan_id FROM V2_Data.pluginlist_view WHERE scan_id = 10539
LIMIT 1
total = 110
> -Original Message-
> From: Daevid Vincent [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 24, 2005 4:20 PM
> To: mysql@lists.mysql.com
> Subject: How can I find the records
I have an "IN()" list of 107 IDs (PK) out of about 6000 possible.
I do this query and I get 105 rows back.
I want to know which two [107 - 105 = 2] of the IDs in the "IN()" list are
absent?
# 105 rows
SELECT count(*)
FROM mytable
WHERE id IN (11704, 10144, 11842, 11299, 11192, 11563, 11378,
lto:[EMAIL PROTECTED]
Sent: Saturday, October 09, 2004 9:30 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Finding records not in a set
Keep in mind EXISTS/NOT EXISTS are for SQL (Parent) Heavy queries
Otherwise you should use IN/NOT IN
Martin Gainty
617-852-7822
Man1: In my next life I w
-
From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 09, 2004 8:48 AM
To: [EMAIL PROTECTED]
Subject: Finding records not in a set
I have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional
I have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional, functionalsubgroup.SubGroup, main_db.Feature,
main_db.FeatureKey, functionalsubgroup.FSKey, featureenable.PlanName
FROM featureenable INNER JOIN (main_db INNER
ex on
'id' in both tables so the join can use an index.
Mike
http://dev.mysql.com/doc/mysql/en/JOIN.html
At 11:03 AM 7/10/2004, you wrote:
I have 2 tables - ProductsOLD and ProductsNEW. I need to find the records
that are in the ProductsOLD table and are NOT in ProductsNEW (this will
Jeff Gannaway wrote:
I have 2 tables - ProductsOLD and ProductsNEW. I need to find the
records that are in the ProductsOLD table and are NOT in ProductsNEW
(this will tell me which products have been discontinued).
Here's some sample data:
+==+
| Produc
I have 2 tables - ProductsOLD and ProductsNEW. I need to find the records
that are in the ProductsOLD table and are NOT in ProductsNEW (this will
tell me which products have been discontinued).
Here's some sample data:
+==+
| ProductsOLD |
+==+
+ Vendor
Hi!
On Jul 06, Barend K?bben wrote:
> It seems the Spatial Extension is not in the 4.1.3 binary (for Win)...?
You're right :(
Sorry for this.
We recently made GIS features optional, but ON by default.
Unfortunately, this "default" is the value of ./configure switch and
does no
It seems the Spatial Extension is not in the 4.1.3 binary (for Win)...?
This is frustating, as I am a GIS/Spatial database developer using until now
succesfully the earlier alpha in my projects. I am not a programmer and certainly do
not want to go into building my own binaries. Why this
Why not search on if it's there, if no results are returned, you know
it's not there.
SELECT count(*) as langcount from db where lang=$lang;
If you want to check for multiple items at once:
SELECT count(*) as langcount from db where lang in ('lang1', 'lang2',
...)
Since you don't want to actual
Hello,
I have several tables that have a common column. I need to check those
tables for 1 of 4 items. If that item does not exist, I jump to a page
saying it is coming soon...
I am passing a variable ($lang) around using php to select info based on
that column.
what would be a suggested sel
Gabriel Alessandria <[EMAIL PROTECTED]> wrote:
> There exists the possibility of doing a SELECT where the list of IN()
clause
> is the result of another select ?
>
> Like this for example
>
>
> Select Number from Phone where Number not in
> (
> SELECT Nu
This functionality exists in 4.1.x versions of MySQL
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/4/04, 8:07:15 AM, Gabriel Alessandria <[EMAIL PROTECTED]> wrote
ult of another select ?
>
> Like this for example
>
>
> Select Number from Phone where Number not in
> (
> SELECT Number from Vendor, Clients
> where Vendor.Number=Clients.Numbe
1 - 100 of 224 matches
Mail list logo
