On Monday 23 January 2006 03:33 pm, Michael Stassen wrote:
> Mark Phillips wrote:
> > I am running mysql 4.0.24 on Debian sarge.
> >
> > I have a table with two columns, "team" and "division", both varchar(255).
> > There are some errors in the table where division has a value but team is
> > bl
Mark Phillips wrote:
I am running mysql 4.0.24 on Debian sarge.
I have a table with two columns, "team" and "division", both varchar(255).
There are some errors in the table where division has a value but team is
blank. Given that I am getting new data, and the data entry folks may create
a r
I am running mysql 4.0.24 on Debian sarge.
I have a table with two columns, "team" and "division", both varchar(255).
There are some errors in the table where division has a value but team is
blank. Given that I am getting new data, and the data entry folks may create
a record with a blank divi
Hello.
You may use these queries:
select flight_id
,baseline*tan(radians(angle)) as attitude
from flights
where (baseline*tan(radians(angle))) =
( select max(baseline*tan(radians(angle)))
from flights f2);
+---+-
I forgot to copy the list as well
Mark
-- Forwarded Message --
Subject: Re: Need Help with a query
Date: Sunday 11 December 2005 06:47 pm
From: Mark Phillips <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Rhino,
My apologies for leaving out t
Oops, I meant to copy the list on this reply so that others could
benefit
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mark Phillips" <[EMAIL PROTECTED]>
Sent: Sunday, December 11, 2005 6:19 PM
Subject: Re: Need Help with a
I have a table with several columns. The ones of interest are flight_id,
angle, and baseline. I want to find the flight_ids for the flights with the
maximum and minimum altitudes, where altitude=baseline*tan(radians(angle)).
For example,
Flights
+++---+
|
At 03:09 AM 6/16/05, Cory Robin wrote:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my
(forwarded to the list - I am not the OP)
- Forwarded by Shawn Green/Unimin on 06/16/2005 11:45 AM -
James Black <[EMAIL PROTECTED]> wrote on 06/16/2005 11:44:36 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] wrote on 06/16/2005 11:
[EMAIL PROTECTED] wrote on 16/06/2005 16:29:46:
>
>
> [EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
>
> > Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
>
> > > I need to speed up a search, big time.
> > >
> > > I have an application that searches for records on a date field
[EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
> Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> > I need to speed up a search, big time.
> >
> > I have an application that searches for records on a date field. If
it
> > doesn't find an exact date match, it keeps searching ad
Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> I need to speed up a search, big time.
>
> I have an application that searches for records on a date field. If it
> doesn't find an exact date match, it keeps searching adjacent days until
it
> finds a certain amount of records.
>
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my application to loop through and run
multip
hi,
that's the same. If you use between, mysql do the rest for you :
mysql> explain SELECT * FROM passengers WHERE
-> reservation_date_time >= '2005-01-01 12:10:00'
-> AND reservation_date_time <= '2005-05-01 12:10:00';
++-++---+---++
resubmitted
Selon [EMAIL PROTECTED]:
> hi,
> that's the same. If you use between, mysql do the rest for you :
>
> mysql> explain SELECT * FROM passengers WHERE
> -> reservation_date_time >= '2005-01-01 12:10:00'
> -> AND reservation_date_time <= '2005-05-01 12:10:00';
>
++-
Sebastian wrote:
Cory Robin wrote:
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date
Cory Robin wrote:
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date_time <= '2005-05-0
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date_time <= '2005-05-01 12:10:00';
--
M
dmond Militante [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 25, 2004 6:03 PM
> To: [EMAIL PROTECTED]
> Subject: need help with a query
>
> hi
>
> i need advice on a query i'm trying to do. i'm trying to find entries with
> that are about to expire. entries
David Perron wrote:
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
True.
I would also format the date comparison to use the same precision that the
DATE_ADD function outputs.
Why would you do that? The date column contains a DATE. CURDATE() retur
Redmond Militante wrote:
hi
i need advice on a query i'm trying to do. i'm trying to find
entries with that are about to expire. entries expire if their date
of submission is older than 60 days. i want to find all entries with
a date of submission greater than 30 days, or those that are going to
)
I might be off on the 1 MONTH part, but I think it's the right track.
-Original Message-
From: Redmond Militante [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 6:03 PM
To: [EMAIL PROTECTED]
Subject: need help with a query
hi
i need advice on a query i'm trying to
hi
i need advice on a query i'm trying to do. i'm trying to find entries with that are
about to expire. entries expire if their date of submission is older than 60 days. i
want to find all entries with a date of submission greater than 30 days, or those that
are going to expire within a mont
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
Hi.
I'm having trouble with a query. I'm wondering if it is possible at all.
I'm making a poll for my webpage. I have two tables:
Poll and poll_votes
Table poll contains data about the poll
Poll_Votes contains all the votes. What I want is to pull out data about the
poll and if the user
* Soheil Shaghaghi
> Hello everyone,
> I need help with MySQL coding in php please if anyone can help.
I can try. :)
> I have 3 tables:
> -users, where the user info is stored.
> -awards: contains the list of all the awards for each user
> -award_types: contains different types of award
> The tab
Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables are at the bottom of the page.
What I need
* Aleksandar Bradaric
> >> select key, desc, value
> >> from your_table t1
> >> where value = (select max(value) from your_table where desc = t1.desc)
>
> > Anyway, when i execute this query, i get an error near 'select
> > max(value)'... :(
>
> It's because the subselects are supported from ve
Hi,
>> select key, desc, value
>> from your_table t1
>> where value = (select max(value) from your_table where desc = t1.desc)
> Anyway, when i execute this query, i get an error near 'select
> max(value)'... :(
It's because the subselects are supported from version 4.1.
If you use older MySQL
Hi,
> I have already tried the 'rtfm', but it just didn't help.
But it's right there :)
3.5.2 The Row Holding the Maximum of a Certain Column
> ..and I want to get this with a single query:
> +-++--+
> | key | desc| value |
> +-++--+
> | 2 | book|
Tibby wrote:
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book| 7 |
| 6 | pen | 7 |
+-++--+
I need to get only one row from col. DESC, the one with the highest VALUE.
With
Hi ppl,
I have already tried the 'rtfm', but it just didn't help.
I have a table:
+-++--+
| key | desc| value |
+-++--+
| 1 | book| 4 |
| 2 | book| 7 |
| 3 | book| 5 |
| 4 | pen | 4 |
| 5 | pen |
I had a query that was working fine before for a
sports project .. basically, 3 tables .. one stored
goal data, one stored team data, and the other player
data. To get all the scoring data (player names,
jersey #'s), I left joined to the player table 3
different times (on GOAL, ASSIST1, and ASSIS
Hi John Kelly,
This is not a perfect solution but may be useful to you. But still with two
queries!
From Mysql prompt issue these two queries.
SELECT @maxcat := max(Category) FROM table
WHERE category = 'Sports:Football:Players' OR
category = 'Sports:Football' OR category = 'Sports';
Select
On Fri, Nov 02, 2001 at 06:15:08PM -0800, John Kelly wrote:
> Hi, I have a MySQL table with a column that contains some of a web site
> directory's category names in the format:
>
> Sports:Football:Players
>
> I am trying to build a query that that locates all records that match the
> above cate
<[EMAIL PROTECTED]>
To: "John Kelly" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 7:09 PM
Subject: Re: Need help with a query ...
> You need to use the LIKE command I think. The MySQL manual should give you
> all the details. If you need
You need to use the LIKE command I think. The MySQL manual should give you
all the details. If you need further help I can just write the whole query
out for you. Or was the problem that you only want to worry about the
if..then stuff if needed? If so could you tell what your pulling back from
tha
Hi, I have a MySQL table with a column that contains some of a web site
directory's category names in the format:
Sports:Football:Players
I am trying to build a query that that locates all records that match the
above category name OR if none exist its parent "Sports:Football" OR if none
exist i
38 matches
Mail list logo
