you are executing this via jdbc, or are you within a mysql prompt?
my guess is if you are in jdbc, and there really are that number of rows
in the table, somewhere a ResultSet.next() is not getting called ....
jeff
Kevin Athey wrote:
>
> I have couple of tables with a few rows, 10-15, with one of the tables
> a 'select * from table' only returns one row, yet on all other tables
> it returns everything.
>
> Any ideas?
>
> Kevin
>
> --
> MySQL Java Mailing List
> For list archives: http://lists.mysql.com/java
> To unsubscribe: http://lists.mysql.com/java?unsub=1
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company jmathis@stripped
525 Camino de los Marquez, Ste 6 http://www.predict.com
Santa Fe, NM 87505
