table1.id=
table2.id AND table1.value=table2.value)
For more details on intersect and minus, check this blog -
http://www.bitbybit.dk/carsten/blog/?p=71
Thanks
Suresh Kuna
On Sun, Oct 16, 2011 at 5:12 PM, Grega Leskovšek wrote:
> WHat is wring with the following three sentences?
>
&g
ender = 'female' AND (e.pizza = 'pepperoni');
SELECT * FROM Person MINUS SELECT * FROM Person WHERE name='Amy';
mysql> SELECT name FROM Person MINUS SELECT name FROM Person WHERE Person.age <
18;
I've tried my first time sets and am not sure where is the p
I would think that:
SELECT email FROM participants
WHERE email NOT IN (SELECT email FROM excluded)
would do the trick
andy
> I am trying to do something like this
>
> select email from participants
> minus
> select email from excluded
>
> It seems there is no minus
select email from participants
minus
select email from excluded
Try an exclusion join (http://www.artfulsoftware.com, "The [Not] exists query
pattern") ...
select email
from participants p
left join excluded e on p.email=e.email
where e.email is null;
PB
-
Brian Menke wr
James Black <[EMAIL PROTECTED]> wrote on 11/22/2005 03:48:28 PM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I am wondering if there is a set-based minus operator.
>
> I am assuming there isn't, but I thought I would ask.
>
> Here is the query I a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am wondering if there is a set-based minus operator.
I am assuming there isn't, but I thought I would ask.
Here is the query I am trying that fails.
Thank you.
select n.name
from names n, transactions t
where n.name=t.name
MINUS
s
use:
innodb-file-per-table
no
instead of
innodb_file_per_table ?
this one (at least for 4.1.11)
[This is just an example]
Can I use only minus sign in the whole CNF file instead of underline ?
no, i think it depends the option configured (..a bit confusing, I know)
Gabriel
--
MySQL Gene
Gabriel PREDA wrote:
I'm going to start the InnoDB engine... and I want to know if the syntax for
the CNF file unified at last ?
Can I use:
innodb-file-per-table
no
instead of
innodb_file_per_table ?
this one (at least for 4.1.11)
[This is just an example]
Can I use only minus sign i
No one ?
Please help me with this.
Gabriel
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 4:36 PM
Subject: Underline or minus sign ?
> I'm going to start the InnoDB engine... and I want to know if the syntax
for
> t
I'm going to start the InnoDB engine... and I want to know if the syntax for
the CNF file unified at last ?
Can I use:
innodb-file-per-table
instead of
innodb_file_per_table ?
[This is just an example]
Can I use only minus sign in the whole CNF file instead of underline ?
Ga
In oracle, intersect will work for you better than minus. as it shows data
from both tables which doesn't exist in another one.
anyway in mysql, you can try this:
select A.* from A left join B on (f1, f2, f3, f4) where B.f1 is null and
B.f2 is null and B.f3 is null and B.f4 is null;
ho
able B has
records that do not belong to table A.
My question is: how to get the records that belongs to A and not to B
and the records that belongs to B and not to A.
If i was using oracle, i guess i could use the minus sql command. More
over, i don't think i can use a simple left join bec
Hi All
MYSQL Supports Unions in 4.0.1.
Similarly any idea when it will support other SET Operators Like Minus
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Description:
When using mysqlhotcopy for database backups, it fails to backup a Database or Table
with a minus ("-") or blanks in its name,
for example when using "mydb.user-table", "mydb.user table", "my db.usertable" or
"my-db.usertable" an
14 matches
Mail list logo