currently, to list the last 100 records in a table I use this sql command:
select * from test order by T desc limit 100;
Note: "T" is the name of a field in my table "test" .
can I instead use record number or use the count function to get the same
result?
I don't have an index field in my table and the table has no primary key
for a good reason.
Also, is this command possible?
select count(*) from table1, table2;
if it is, why can't I get the correct result:
table1 has 337 records and table2 has 23860 records but the result is
8040820 instead.
thanks
--------------------
Nissim Lugasy
216-433-2708
[EMAIL PROTECTED]
--------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
