If not specified via command line options, by default MySQL will only
return a maximum of 1000 results on a select query. The manual provides
a list of options in the 'Command Line Tool' section. Also,
SQL_BIG_SELECTS should be set to 1, but that's the default so you
shouldn't have a problem with that. Just as an afternote, a 'big' select
in MySQL is where a select query will have to examine more rows than is
defined by the max_join_size option. I found this out fairly quickly the
first time I encountered this as one of my tables contains 39,000
records in it :-)
Armando
-----Original Message-----
From: John Philip [mailto:johnphilip@stripped]
Sent: Friday, January 02, 2004 2:47 AM
To: arjun@stripped
Cc: win32@stripped
Subject: RE: Importing records from access to mysql
HI,
I am sorry, all the records were imported,but Mysql has by default some
limit record display.
In mysqlfront it shows appropritky
Regards
John philip
-----Original Message-----
From: arjun@stripped [mailto:arjun@stripped]
Sent: Friday, January 02, 2004 13:41
To: John Philip
Cc: win32@stripped
Subject: Re: Importing records from access to mysql
Could you give more information regarding the import? What are the
coloumn
types ? What type of table is it ? How did you do an import ? Anything
else
would be helpful
Quoting John Philip <johnphilip@stripped>:
> Hi
> I imported a access table containing 1600 records to mysql. But i can
> see only 1000 records in it. any restriction of this in MySQL.
>
>
> Regards
> John Philip
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=1
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=1
