mysql> create database colors;
Query OK, 1 row affected (0.01 sec)
mysql> use colors
Database changed
mysql> CREATE TABLE Colors(
->
-> cid INT UNSIGNED NOT NULL,
-> data VARCHAR(10) NOT NULL
-> );
Query OK, 0 rows affected (0.06 sec)
mysql> insert into C
Sorry I misread what the question was asking since I have run into MySQL
related problems that are not problems in other databases, so I just wanted
to check that out. You would have to have some function that could read a
resultset similar to the "select * from colors where data !='blue';" since
In your examples, ID 2 should NOT get returned. What I'm after is analogous to a Perl
hash where you could say:
if (!exists $colors{2}->{blue}) {
...
}
Make sence?
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
mysql> create database colors;
Query OK, 1 row affected (0.01 sec)
mysql> use colors
Database changed
mysql> CREATE TABLE Colors(
->
-> cid INT UNSIGNED NOT NULL,
-> data VARCHAR(10) NOT NULL
-> );
Query OK, 0 rows affected (0.06 sec)
mysql> insert into C
[EMAIL PROTECTED] writes:
> database,sql,query,table
Fscking piece of crap filter. :-P Why not just forbid posts
from people not on the list and have new members approved
manually? Nooo... must annoy the users. Blaergh.
> > I'd like to be able to get back all of the IDs that don't have 'blue',
I have some hanger data that can be grouped by a common column to get back a list of
multiple values. These values are logically one data set belonging to parent data.
Nothing strange about that. Now I want to make an exclusionary query over those
multi-value sets. For instance, I've got data