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
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
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
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