> Jonas, > > try to execute this command: > > SELECT count(1) FROM table_name; > > Result should be 28. Do you have 28? > > Mikhail.
Yes, it says: -- SELECT count(1) FROM table_name; +----------+ | count(1) | +----------+ | 28 | +----------+ 1 row in set (0.00 sec) -- // Jonas Olofsson > > Hi. > > > > I have just started to use MySQL and I have come up with a strange > > problem. > > > > I have a table with 28 rows. When I do 'SELECT * FROM > table_name;' in > > the MySQL client it only shows 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? > > > > // > > Jonas Olofsson > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
