Alternatively, you could just code a recursive function to do the same
instead of doing it in SQL or stored procs.
On Tue, Aug 24, 2010 at 11:01 AM, Victor Subervi wrote:
> On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley
> wrote:
>
> > >What I'm trying to accomplish is to order the results such th
On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley
wrote:
> >What I'm trying to accomplish is to order the results such that after
> >stacking the data for all results for a certain category, that the next
> >results to be stacked should be those whose parent = the former category,
> >then move on to
>What I'm trying to accomplish is to order the results such that after
>stacking the data for all results for a certain category, that the next
>results to be stacked should be those whose parent = the former category,
>then move on to the next category, etc. How do I do this?
It's a tree. See
ht
It worked like a charm.
Thanks for the help!
Andre
On 22-Sep-08, at 2:58 PM, Jim Lyons wrote:
look at using the "group_concat" function on OptionalDesc and group
by the other fields.
On Mon, Sep 22, 2008 at 1:40 PM, Andre Matos <[EMAIL PROTECTED]
> wrote:
Hello,
I need help with a SQL
look at using the "group_concat" function on OptionalDesc and group by the
other fields.
On Mon, Sep 22, 2008 at 1:40 PM, Andre Matos <[EMAIL PROTECTED]>wrote:
> Hello,
>
> I need help with a SQL Select statement:
>
> I have three tables: report, category, and optional
>
> a) "report" table has 3
Scott Haneda <[EMAIL PROTECTED]> wrote on 11/16/2005 05:44:05 AM:
> Some of these tables are rather large, I would put the schema in there,
but
> I think it just adds to the mess.
>
> Tables
> `users` field id is auto inc pk
> `orders` field id is auto inc pk
> `products` field id is auto inc pk
]
Subject: RE: Complex select statement
Still having a problem with this. Still have one last thing that isn't working. This
is MySQL 4.0.13.
UPDATE table_tmp,table2_daily SET table_tmp.period_count = table_tmp.count -
table2.count WHERE table_tmp.id = table2.id AND MAX(table2.timestamp);
ilto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 4:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy W
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy Walker wrote:
Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13.
UPDAT
ow to do it 4.1! Please! :)
Roy
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:49 AM
To: Roy Walker; [EMAIL PROTECTED]
Subject: RE: Complex select statement
I never heard before that you can use a select statement in an arithmetic expression.
Onl
ld also be the way how I would do it in a different DB (e.g. ORACLE).
Cheers
/rudy
-Original Message-
From: Roy Walker [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 18:30
To: [EMAIL PROTECTED]
Subject: RE: Complex select statement
Eva,
Thanx for your help. Still having an issue
st regards
Nils Valentin
Tokyo/Japan
>
> Thanx,
> Roy
>
> -Original Message-
> From: "Paracková Eva, Ing" [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 11, 2003 12:30 AM
> To: Roy Walker
> Subject: RE: Complex select statement
>
> try this:
>
>
ge-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
"Roy Walker" <[EMAIL PROTECTED]> wrote:
>
> Thanx for your help. Still having an issue with this. I forgot to
ment
"Roy Walker" <[EMAIL PROTECTED]> wrote:
>
> Thanx for your help. Still having an issue with this. I forgot to mention I am
> running MySQL 4.0.13. Tried both of these statements:
>
> INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
> (SELECT count FROM table2
for the 'SELECT count FROM table2 WHERE id=id1' section.
Is this illegal syntax? Would this be considered a subselect?
Thanx,
Roy
-Original Message-
From: "Paracková Eva, Ing" [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:30 AM
To: Roy Walker
Subject
15 matches
Mail list logo
