Re: How to retrieve the lastest update or insert record?

2002-05-27 Thread Peter Fleming
Hi Jack select * from TableName order by DateTimeField DESC limit 5 Should do it. Peter At 05:04 PM 5/27/2002 +0800, Jack wrote: >Dear all > I had a table which containing (date/time) field, now i want to retrieve 5 >most latest update / insert record from that table, what query should i us

RE: MySQL + ODBC + palm + security?

2001-08-25 Thread Peter Fleming
Hi I'd also like to know the answer to this. I also had a thought that it might be nice to have a site to post answers that come through this email list. I know there are archives but they can be difficult to use to find the "answer" to peoples questions. What does everyone think about havi

Fwd: Error with RPM upgrading from 3.22.23 to 3.23.40

2001-08-06 Thread Peter Fleming
Well, I answered by own question. The trick is to install the client utilities first! Then the server. ie: rpm -Uvh MySQL-client-3.23.40-1.i386.rpm rpm -Uvh MySQL-3.23.40-1.i386.rpm Peter >Date: Mon, 06 Aug 2001 15:27:14 -0400 >To: [EMAIL PROTECTED] >From: Peter Fleming <[EMA

Error with RPM upgrading from 3.22.23 to 3.23.40

2001-08-06 Thread Peter Fleming
Hi I'm receiving the following error when trying to upgrade from 3.22.32 to 3.23.40 OS: RedHat Linux 6.1 Hardware: HP Netserver E60 After closing down the MySQL daemon, then issue: rpm -Uvh MySQL-3.23.40-1.i386.rpm I get errors, saying that there is a conflict with mysqldump. Any ideas would