Please post the entire contents of SHOW CREATE TABLE for this table and we
will have enough information to answer your question.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED] wrote on 08/13/2004 09:48:21 AM:
If I want to update these day fields in this
john henry bonham wrote:
If I want to update these day fields in this table:
day, date, month, year
-1 August 2004
-1 August 2004
I want on to be Sunday Lunchtime the other to be Sunday Evening. What
query do I use that won't update both fields with the same data?
maybe something
You were so very close to getting what you wanted!
What is causing the problem is the comma (,) in your FROM clause. MySQL
permits two methods of declaring an INNER JOIN. The first is by using the
keyphrase INNER JOIN the second is with a comma in your table list. Here
is how to rephrase your
To get http://www.google.com/; out of the URL, you can do this:
LEFT( referer, LENGTH( SUBSTRING_INDEX( referer, '/', 3 ) ) + 1 )
If you don't care about the trailing slash, you can use just the
SUBSTRING_INDEX() portion:
SUBSTRING_INDEX( referer, '/', 3 )
Using the LENGTH() function just helps
Just a follow-up oops...
I misread the manual page when verifying the SUBSTRING_INDEX() syntax.
It states that it returns everything before _count_ instances of the
delimiter, so naturally if you feed it a value that exceeds the actual
instances of the delimiter, you get back the whole
On 15 Jul 2004 at 6:27, Patrick Drouin [EMAIL PROTECTED]
wrote:
I'm having a hard time with the following query. It
retrieves about 3K rows from a few tables. One of them
contains over 40M rows. When run on a 3Ghz server with
1G of RAM it returns the rows in more than 1 mini. I
don't think
Bonjour Arnaud,
--- Arnaud [EMAIL PROTECTED] wrote:
On 15 Jul 2004 at 6:27, Patrick Drouin
Your indexes look good, but I see that you have some
varchar fields.
Maybe
you could run an optimize table on these tables?
I'm running it at the moment, I will follow-up on the
list when it's done.
What version of MySQL are you using? Have you checked the cardinality on
these tables?
-Original Message-
From: Patrick Drouin
To: [EMAIL PROTECTED]
Sent: 7/15/04 8:27 AM
Subject: Need help optimizing query
Hello everyone,
I'm having a hard time with the following query. It
retrieves
Hello Victor,
What version of MySQL are you using? Have you
checked the cardinality on
these tables?
Problem solved! Optimizing the table brought the query
time down to 17 secs Wow!
Thanks for the input Victor and merci to Arnaud for
the quick fix.
Patrick
It sounds like you are missing indexes.
Please post the results of -
SHOW CREATE TABLE ImportLiebermansStep3Add;
- and -
SHOW CREATE TABLE ProductsOld;
- and we can tell you if you have enough indexes or not.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Could someone who has experience with handling the Unicode character
set in a MySQL database please write to me? In particular, I am
trying
to discover how in an ASCII-limited environment one can specify
non-ASCII characters; I do know their Unicode encodings, just not how
to write an
Jeff
Why are you doing a LEFT JOIN instead of a INNER JOIN
right now you are getting all rows from first table regardless of match
condition so all of the rows for
a.ProductID FROM ImportLiebermansStep3Add
are being returned
try the inner join instead
Martin
- Original Message -
From: Jeff
Hi Aaron,
Having a problem with a query that's returning 486,057 results when it
most definitely should NOT be doing that.
I have two tables:
1 for a list of customers that purchase product A, another for customers
who purchased product B.
Columns are:
Id
First
Last
Email
I am
It sounds like a cartesian join. Have you run an explain plan on this query?
What are you joining the two tables on?
-Original Message-
From: Aaron Wolski
To: [EMAIL PROTECTED]
Sent: 7/9/04 10:33 AM
Subject: anyone help with this query? Returning to many results
Hi all,
Having a
Aaron Wolski [EMAIL PROTECTED] wrote on 09/07/2004 16:33:27:
Hi all,
Having a problem with a query that's returning 486,057 results when it
most definitely should NOT be doing that.
I have two tables:
1 for a list of customers that purchase product A, another for customers
who
From the documentation
mysql SELECT table1.* FROM table1
-LEFT JOIN table2 ON table1.id=table2.id
-WHERE table2.id IS NULL;
will normally give you the right answer.
and you should get : 2026 x 240 - 486,057 = 183 results
Aaron Wolski wrote:
Hi all,
Having a problem with a
You have written a cross-product join. This is what happened but with a
much smaller example:
Assume you have two tables: Colors and Sizes
CREATE TABLE Colors (
id int auto_increment primary key
, name varchar(10)
);
CREATE TABLE Sizes (
id int auto_increment primary key
of
those customers who DO have email address that matches in each table?
Thanks again guys. Very much appreciated!
Aaron
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: July 9, 2004 12:17 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: anyone help
Subject: RE: anyone help with this
query? Returning to many
PMresults
Subject: RE: anyone
help
with this query? Returning to many
PMresults
Hi all,
First... I just want tot hank everyone for their help and explanations
of how I was going wrong, and the measures to correct my logic!
Great
Hey Rob,
You're looking for a group by to allow mysql to aggregate over the IP's:
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY ip DESC limit 10;
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject:
select count(*) as cnt group by ip order by cnt desc limit 10;
rmck wrote:
Hi,
I have a table with ip,port and I want to see the top ten Ip's with the most entries?
Ip's can be in db many times...
Not the first distinct 10... Im stuck...
I have tried:
mysql select DISTINCT ip from iptable limit
Woops! Forget I said that, you wanted to order by the most occurrences.
Sorry.
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY 2 DESC limit 10;
Heh... I should learn to read one of these days...
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July
On Thu, 2004-07-01 at 10:03, rmck wrote:
Hi,
I have a table with ip,port and I want to see the top ten Ip's with the most
entries?
Ip's can be in db many times...
Not the first distinct 10... Im stuck...
I have tried:
mysql select DISTINCT ip from iptable limit 10;
You need to flip the business table around your join so that you get all of
the businesses listed and check for the appropriate NULL values in the
other tables.
This will give you all of the business that neither have a record in 2004
nor will they be part of package 16
SELECT *
FROM business
]
PM Fax to:
Subject: Re: Query Help
Robert A. Rosenberg wrote:
At 12:22 +0100 on 06/11/2004, Andrew Dixon - MSO.net wrote about Query
Help:
Hi Everyone.
I have the following a table with a varchar column that contains a comma
delimited list of id's from another table that relates the item
keywords in
the other table.
The table
At 12:22 +0100 on 06/11/2004, Andrew Dixon - MSO.net wrote about Query Help:
Hi Everyone.
I have the following a table with a varchar column that contains a comma
delimited list of id's from another table that relates the item keywords in
the other table.
The table keywords contains
keyword_id
First, you really should add a gallery_keywords relationship table to
replace the galleries.keywords column. Aside from the difficulties you are
already having, I don't think any solution with the current scheme will be
able to make full use of indexes, if at all. In other words, without an
For example:
gallery_id | gallery_name | keywords
1 | test | 1,2,3,4
2 | test2| 3,4,5,6
And I won't to get all the galleries with where the have the
keywords 2, which in this case would be record 1 or keyword 4
which would be both record.
SELECT
]
Subject: RE: Query Help
For example:
gallery_id | gallery_name | keywords
1 | test | 1,2,3,4
2 | test2| 3,4,5,6
And I won't to get all the galleries with where the have the keywords
2, which in this case would be record 1 or keyword 4 which would be
both
Already tried that, but is 2 appears at the end of the list
is doesn't get picked up because there is no comma at the end
of the list
Are there spaces between the commas???
If not then
SELECT gallery_id, gallery_name
FROMgalleries
WHERE
keywords = '2'--
-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]
Sent: 11 June 2004 12:58
To: Andrew Dixon - MSO.net; [EMAIL PROTECTED]
Subject: Re: Query Help
Hi,
You could use either something like this
SELECT gallery_id, gallery_name
FROM galleries g
WHERE keywords rlike
On Sat, 5 Jun 2004 21:10:42 -0600
Daniel Isenhower [EMAIL PROTECTED] wrote:
First off, I assume you are using a version of mysql able to
handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
No worries, there are too many versions
On Sat, 5 Jun 2004 19:48:44 -0600
Daniel Isenhower [EMAIL PROTECTED] wrote:
This is my first email to the list, so be nice ;-)
Welcome, this is a very helpful list...
I'm having some difficulty with a subquery that I'm trying to do,
and was wondering if anyone here can shed some light on the
First off, I assume you are using a version of mysql able to handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
FWIW, this is an easy query with a JOIN:
SELECT id FROM work w
INNER JOIN client_list cl ON cl.id = w.client_id
WHERE
Bob Lockie wrote:
What I really want was
mysql update records set records.prio=2 where records.in=(select
records.id from records, audit_log, audit_log_records where
audit_log.tracker_id=audit_log_records.tracker_id and
records.id=audit_log_records.id and audit_log.operation='D' and
Bob Lockie [EMAIL PROTECTED] wrote:
What I really want was
mysql update records set records.prio=2 where records.in=(select
records.id from records, audit_log, audit_log_records where
audit_log.tracker_id=audit_log_records.tracker_id and
records.id=audit_log_records.id and
man i didnt even know you can do this
AND s.date q.date
i assumed that goes in a where clause ?
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
Sent: Wednesday, May 26, 2004 8:01 PM
To: [EMAIL PROTECTED]
Subject: Re: need help with a complicated join
:
Sent by: newsFax to:
[EMAIL PROTECTED]Subject: Re: need help with a
complicated join
rg
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; news
Subject: Re: need help with a complicated join
Harold, you win the EUREKA prize of the month!
I had forgotten all about that silly algebraic trick. This answers another
person's post from last week. (I will try to find it again) also looking
At 14:07 -0500 on 05/25/2004, [EMAIL PROTECTED] wrote about need
help with a complicated join:
I am trying to come up with a query that takes two tables, one with
non-split-adjusted historical stock prices, and one with information on
splits, for instance:
CREATE TABLE quotes (
symbol
On Tue, 25 May 2004 11:50:11 +0100, Paul Owen [EMAIL PROTECTED] wrote:
What I have so far is:
from people, invoice, payments
where people.pid=invoice.pid
and people.pid=payments.pid
group by people.pid;
Though it doesn't fix the problem you're asking about, I wanted to
note that you'll
You are beyond the realm of SQL. What you would need for something like
this is a dynamically-generated case statement that would apply different
multipliers based on the date of the quote you are trying to adjust. For
those quote values that exist BEFORE multiple splits you must adjust by the
Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
| 1 | 2004-05-20 10:46:12 | QUAR | 80 |
| 2 | 2004-05-20
Egor Egorov [EMAIL PROTECTED] wrote:
Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
| 1 | 2004-05-20 10:46:12 |
On Thursday 20 May 2004 12:49, Egor Egorov might have typed:
Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
Since your on 4.1, give this a try...
select *
from tbl as a
where a.recdate=(select max(b.recdate)
from tbl as b
where b.id=a.id and b.mount=a.mount)
Ed
-Original Message-
From: Duncan Hill [mailto:[EMAIL PROTECTED]
Subject: Re: Query help
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have enough ram to hold all the data, ram is
probably not your
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote:
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have
It sounds like someone upgraded your PHP libraries, and forget to include
MySQL support. Do you admin this server, or does someone else?
j- k-
On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
Joshua J. Kugler [EMAIL PROTECTED] wrote on 05/03/2004 12:23:16 PM:
It sounds like someone upgraded your PHP libraries, and forget to
include
MySQL support. Do you admin this server, or does someone else?
j- k-
Yep, I ran phpinfo.php and verified that it no longer shows support
Andre,
have a look at JOIN. This can solve your problem.
Thomas Spahni
On Fri, 30 Apr 2004, Andre MATOS wrote:
Is it possible to create a Select performing a math formula? For example:
First I need to add two values come from the same table but from different
records. The result will be
Andre MATOS wrote:
Hi,
Is it possible to create a Select performing a math formula? For example:
First I need to add two values come from the same table but from different
records. The result will be divided from one number got from another
table. Now, the new result will be added with
Hi Robert,
the criteria for the record_1 and record_15 is that both are in the same
table, but in different records and to find each one it is necessary to
perform a WHERE clause.
Let's I give you the real example:
My problem is while inserting a new record in my table named
Thank you very much Shawn and Mike for your quick responses. Left join
was exactly what I was looking for and it worked quite nicely.
Once again, thanks for your help.
Richard
[EMAIL PROTECTED] wrote:
Richard,
This is the case for using a LEFT JOIN. You want everything from the left
table
From: Richard Reina [mailto:[EMAIL PROTECTED]
I have two tables:
EVENT
IDname date
sponsor_ID
23 Sady Hawkins 2004-11-04 235
89 Founders Day 2004-12-21 NULL
87 Winter Gala
Richard,
This is the case for using a LEFT JOIN. You want everything from the left
table regardless of if it has a match in the right table. In this case
which table is left or right depends on which table name exists to the left
of the JOIN clause.
This will show you all events regardless if
I got a response off the list suggesting writing a function to go over
the query results- it's not hard but I'd rather do this in sql if possible.
I came up with this:
select books.bookid,books.title,copies.copyid from books left join
copies on books.bookid=copies.bookid where
Yonah Russ [EMAIL PROTECTED] wrote:
Hi,
I have two tables- books and copies
every book has an id in the books table
every copy of a book has the books id and a copy id in the copies table
(1 row per copy)
I want a list of all the books that don't have any copies meaning all
the book
[mailto:[EMAIL PROTECTED]
Sent: 21 April 2004 14:47
To: MySQL List
Subject: Re: query help
I got a response off the list suggesting writing a function to go over
the query results- it's not hard but I'd rather do this in sql if
possible.
I came up with this:
select books.bookid,books.title
Why not try to create a full text index on the column?
-Original Message-
From: jeroen clarysse
To: [EMAIL PROTECTED]
Sent: 4/16/04 9:00 AM
Subject: Need help with indexing !
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called
I get an error when trying to reset password.
I start the db using:
mysqld_safe --skip-grant-tables
and reset the pwd using the mysqladmin command...
below is the error message.
mysqladmin: unable to change password; error: 'Can't find any matching row in the user
table'
thanks,
--
MySQL
Please look in your data directory and post the contents of the host
name.ERR file that you find there. That will give folks the information
they need to help solve your problem.
-Original Message-
From: Ginger Cheng [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 10:21 AM
To:
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ginger Cheng [EMAIL PROTECTED] wrote:
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your
That did it. I really do appreciate all of the help that I received from you
and the list.
Thanks again. :)
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 7:52 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating
Hi, the table name and the column names dont have to be inclosed by ' '.
Carlos
Original Message Follows
From: Marvin Cummings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Need help creating table...
Date: Tue, 6 Apr 2004 12:29:48 -0400
_
From: Marvin Cummings
Marvin Cummings writes:
I attempt to create this table from the command line and get the following
error:
Marvin,
the use of the ' [single quote] appears to be your problem. I've
been able to create the table on 4.0.18 using the following syntax:
CREATE TABLE nuke_zc_ads
(
ad_id
Looks like you are using backticks instead of single quotes on your
column names. You don't really need the quotes on your table name or
column names anyway, so I'd just remove them.
On Tue, 2004-04-06 at 09:29, Marvin Cummings wrote:
_
From: Marvin Cummings [mailto:[EMAIL
Marvin Cummings wrote:
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL
Sorry. I can imagine how frustrated you must be.
In mysql 5, condition is a reserved word, so the person who told you to
remove the quotes was wrong, at least for that column. (In his defense,
CONDITION is relevant to stored procedures, so it isn't a reserved word for
versions prior to 5, as
Marvin Cummings wrote:
Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads:
(
`ad_id` smallint(5) unsigned NOT NULL
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 7:49 PM
To: [EMAIL PROTECTED]
Subject: urgent help needed
cc
Subject
RE: urgent help needed
sounds like you need a join.
Select * from Poll, poll_votes where (Poll.poll_id = poll_votes.poll_id) and
(poll_votes.user_ID = WHATEVER);
But I'm still a beginner so
Respectfully,
Ligaya Turmelle
Anders Gjermshus [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi.
I'm having
Hiep Ho [EMAIL PROTECTED] wrote:
i have problem adding user to mysql. I can create a database and there is no
problem however I got this ERROR 1047: Unknown command when I tried to add
new user. I don't think I have this problem before.
I run this command
GRANT ALL ON *.* TO usename
I think you need the DISTINCT operator.
Assuming you haven't seen it, it works like this. Let's say that your query
asks for a list of all the job titles in your employee table, where the job
title is one of the columns of that table. The employee table looks like
this:
EMPNO NAME JOB
1
Kris Burford [EMAIL PROTECTED] wrote:
hi
wondering whether someone can set me straight on whether it's possible to
request a set of records from a single table with multiple conditions.
for instance, a story table, containing id, title, text, section and
published_date. what i would
Hello Rob,
Friday, March 12, 2004, 7:39:47 PM, you wrote:
RA ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Using
password: YES
Does that user actually exist within MySQL? I have you used the
mysqladmin program and created a user account called ackerley? If not,
that's why you can't
Is this user a super user, or do they only have access to a single DB?
If they are a super user, try changing the password using mysqladmin -u
ackerley password 'newpassword'
If this user only has access to a single db, alter your mysql command to:
shell mysql -u ackerley -p 'database_name'
Then like Richard Davey sent earlier to the list, try:
shell mysql -u root
If you haven't created the users yet with the mysql tool, then your user
won't have access to it. First, change the root password using:
shell mysqladmin -u root password 'new_password'
Then log into mysql and use:
mysql
Erica L Ridley [EMAIL PROTECTED] wrote:
I need help with rewriting a sql query. Nested queries that work in MS
databases apparently do not work in MySQL databases. Here is what I need
in MS query pseudo code:
SELECT table1.myfield1, table2.myfield2
FROM table1, table2
WHERE
Hello CurlyBraces,
Wednesday, March 3, 2004, 1:22:51 PM, you wrote:
CTPL SO i want to add colors for this status.
CTPL up = green
CTPL down = red
CTPL how can i do that ? can some body help me ..plz
You asked this question a few days ago, didn't you read the reply you
got last time?
If you are wanting a checkbook like display then each entry is either a
debit or credit and each is on its own line.
Your query will display this. I would add an ifnull to display a zero
when the the debit/credit is null.
Original Message
On 3/2/04, 10:50:15 AM, charles kline [EMAIL
Charles:
I am not quite sure by what you mean, How do I get it to show me as I
like, one in and one out per line, rather then an in for every out and
vice-versa?
It seems for your example below you want a result set of 4 rows
I don't think your design is appropriate, however your suggestion at
Boyd,
Thank you very much for the design help... this is just what I am
looking for, just wasn't clear how to best do it :)
BTW, you can use a case statement to help with signing the number
properly. I just discovered this the other day and am really tickled
with it!
I am not very experienced
: [EMAIL PROTECTED]
Subject: RE: Query Help
At 2:45 + 2/29/04, John Berman wrote:
Got it working at last
SELECT lists_.DescShort_ FROM lists_ WHERE (((lists_.Name_) Not In (select
members_.List_ from members_ where members_.EmailAddr_ like (' em
' union SELECT lists_.DescShort_ FROM
: Sunday, February 29, 2004 3:54 AM
Subject: RE: Query Help
Paul
Sorry to be a pain. I'm not sure that I understand
Select an extra column in each SELECT. SELECT member, ... UNION
SELECT non-member, ...
Regards
John Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL
Rhino
This is great it works a treat
Thanks
Regards
John Berman
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note
Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note was sent to the whole
group
The technique Paul is describing involves adding another
At 23:09 + 2/28/04, John Berman wrote:
Hi
Using MySql 4.x and need some help with a query
There are two tables
Lists
Which holds list name +other stuff
Members
Which holds list name from above, email address + other stuff
I want to list all the lists and then which lists a member is
601 - 700 of 1409 matches
Mail list logo