Re: hi, I am not able view all the records in the tabel

[Chris]

Annam Srinivas wrote:

Hi,

  Problem is like this. There is table with 'table_name-1'  where, when I
am executing the query like ' select * from table_name-1;' it is showing
only 432 records but acctually there are 539 records in the table. when I
select individual records from the table it is showing (able to view the
record data) from 1, . . . 539 record.


How do you know there are 539? Did you count them by hand?

There could be id's missing in the list, eg:

1
2
3
-- 4 is missing
5


where records have been deleted.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

hi, I am not able view all the records in the tabel

[Annam Srinivas]

Hi,

  Problem is like this. There is table with 'table_name-1'  where, when I
am executing the query like ' select * from table_name-1;' it is showing
only 432 records but acctually there are 539 records in the table. when I
select individual records from the table it is showing (able to view the
record data) from 1, . . . 539 record.

  I want all the records to be displayed when i select using 'select * from
table_name-1;'.



Regards
A Srinivas