Hi All,
Well I think I actually managed to fumble my way to a solution to this. I
took the example avg_cost UDF function and modified it somewhat (well,
hacked it to pieces). I've tried this before but I actually tried to
rewrite it, bad mistake. This time I just deleted all the bits I didn't
1.* from TempTable tt, TheTable l1 Where
tt.IDField, t1.IDField
Finally you drop the temp table:
drop table if exists TempTable
This could have been achieved in one step with
sub-queries but MySql does not support them.
I hope it helped.
--- Miles Roper <[EMAIL PROTECTED]> wrote:
> Hi
son [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 9 July 2002 05:37
To: 'Miles Roper'; '[EMAIL PROTECTED]'
Subject: RE: UDF, Can anyone please help?
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
Tha
I'm keeping an eye on the mailing list via the net. :o) I get to many
emails as it is :o)
Hope this makes sense :o) Thanks for you help.
Cheers
Miles
-Original Message-
From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 9 July 2002 03:38
To: Miles Roper; &#
Hi,
I've being trying for the last couple of months to convert a MS Access to
Mysql. I pull out data extract from around 100 + queries. These took about
5 months of solid work to develop and are extremely complex. I can convert
these to mysql, but have one big problem. There is no last functi
ut this its going to make it pretty
difficult.
Ideas or alternative solutions anyone?
Thanks Heaps
Cheers
Miles Roper
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
