Hi,
I wanted to ask some more experienced mysql users to give me some advice on
a project I am currently planning.
I have a text file with three columns: strName(char6), position(integer),
str(char36)
This file has some 3 billion rows (3,000,000,000). There are some strs
that are duplicated
Hi,
I have a query where I want to retrieve all the people who are not in
a specific group. Like so:
SELECT id, name FROM people WHERE group_id != 3;
Since people may not be in a group at all, I also need to test if the
column is NULL:
SELECT id, name FROM people WHERE group_id
I'm sorry for the rant, but nulls in databases make me see red! NULLS
ARE GARBAGE!
You are using a 'NULL-safe equal to operator', meaning, WHERE NOT
group_id = 3, and oh, by the way, I DON'T WANT ANY NULLS TO QUALIFY AS 3.
And yes this will be much slower, because now we can't use the
Running 4.1.22-standard, I have two simple MyISAM tables:
Table: temp_del_ids
Create Table: CREATE TABLE `temp_del_ids` (
`cust_id` int(11) NOT NULL default '0',
PRIMARY KEY (`cust_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
and
Table: cust_campaigns
Create Table: CREATE TABLE
On Friday 13 March 2009 09:48:36 Michael wrote:
I'm sorry for the rant, but nulls in databases make me see red! NULLS
ARE GARBAGE!
You are using a 'NULL-safe equal to operator', meaning, WHERE NOT
group_id = 3, and oh, by the way, I DON'T WANT ANY NULLS TO QUALIFY AS 3.
And yes this will
On Friday 13 March 2009 09:48:36 Michael wrote:
I'm sorry for the rant, but nulls in databases make me see red! NULLS
ARE GARBAGE!
You are using a 'NULL-safe equal to operator', meaning, WHERE NOT
group_id = 3, and oh, by the way, I DON'T WANT ANY NULLS TO QUALIFY AS
3.
And yes this
2009/3/12 Carl c...@etrak-plus.com:
I am still a little puzzled about how we could have a relatively large set
of records (100,000+) and yet not cause any table to be locked as the server
has only 8GB of memory.
What's the relationship you're implying between memory and locking?
Multi-version
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design, the
less complex it will be to retrieve reliable information out of it.
Furthermore, (and this is
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design,
the
less complex it will be to retrieve reliable information out of it.
Furthermore, (and this
I'm hoping someone can point me in the right direction for what I need,
to save me trawling through books and Google when I don't know what I'm
looking for.
I'm using an INNER JOIN to query a table that has a one-to-many
relationship with the table in my FROM clause, but I only want one
ggghh
mich...@j3ksolutions.com wrote:
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design,
the
less
Nigel Peck wrote:
...
My query is:
SELECT
`People`.`person_id`,
`People`.`name`,
FROM
`People`
INNER JOIN
`Person_postal_addresses`
ON
`Person_postal_addresses`.`person_id` = `People`.`person_id`
WHERE
`People`.`name` REGEXP 'example'
OR
mich...@j3ksolutions.com wrote:
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design,
the
less complex it will be to retrieve reliable
Exactly the point. Michael, NULL *is* information. It means unknown and
that is in itself useful information. A common example:
A new employee is hired but which department she will work in is unknown. So
the data entry person enters all the known information and leaves the rest
until it has
On Fri, Mar 13, 2009 at 3:20 PM, Andy Wallace awall...@cisdata.net wrote:
ggghh
mich...@j3ksolutions.com wrote:
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and
15 matches
Mail list logo