RE: Hidden rows in table.

2002-06-29 Thread Jonas Olofsson
> Hi, > > Perhaps the table is corrupted ? (the second query uses index > if they is one whereas the first doesn't). REPAIR TABLE > reports nothing wrong ? > > Regards, > Jocelyn Just use that, and now it seems to work... Thanks everyone... // Jonas

RE: Hidden rows in table.

2002-06-29 Thread Jonas Olofsson
hows 12 of these rows. But if i > specify one > > of the rows that are not shown with the first command, like > 'SELECT * > > FROM table_name WHERE id='25';' this row is shown. > > > > Any suggestions what might be wrong? > > >

Hidden rows in table.

2002-06-29 Thread Jonas Olofsson
7;SELECT * FROM table_name WHERE id='25';' this row is shown. Any suggestions what might be wrong? // Jonas Olofsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l