Hi,
Is it possible to select the last 10 rows from a table in the order of their
IDS, without making a separate query for finding the number of the rows?
I am thinking to something like:
select * from table_name order by date desc, time desc limit 10;
This will select the last 10 rows, but i
select * from (select * from table_name order by date desc, time desc limit
10) order by date asc, time asc;
HTH,
Panos.
On 12/30/06, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
Hi,
Is it possible to select the last 10 rows from a table in the order of
their
IDS, without making a separate que
Philip Mather wrote:
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as
root? You also say you can only see a "test" da
I am getting the same result in Java code, i.e. the resultset returned is
non-null even though the primary key value is not found in the table.
Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/29/06, murthy gandikota
wrote:
> I am posting the relevant JSTL code.
Just to clarify: you're *not
Mohsen,
Philip Mather wrote:
Mohsen,
First off, what version of MySQL are you running and on what
platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as
root? You also say you can only see a
