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
That might get the correct answer for you
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 Frank,
Good idea
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
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; '[EMAIL
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
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/ (the list archive