Phil, Friday, June 14, 2002, 6:14:49 AM, you wrote: PR> I've been trying to "select * table" as a way to review a large table in PR> mysql. But only 1000 rows are returned, whereas there should be about 1200 PR> rows in all. Is this a limitation in mysql? Is there a configuration file PR> where it can be reset to a higher value? Thanks in advance. Phil Reardon
No, there is no such limitations in MySQL. Are you sure that table contains about 1200 rows? What is the result of SELECT COUNT(*) FROM table_name -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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