wasabi3689
asked on
why I have to put limit in the query
I have MS SQL 2008 and visual studio. I have MySQl query run in Visual studio by MySQl connector. For whatever reason, when I put "limit 2000000" in the MySQL query, it returns correct records. But, when I remove "limit 2000000" in the MySQL query, it returns null. I don't understand why. I want to remove "limit 2000000"
When I use MySQL editor from MySQL front to run the query without limit set, it returns the same records. I don't understand why in Visual Studio connecting to MySQL, I have to put a limit set in query???
Here is the query structure
select ...
from table
where...
limit 2000000
When I use MySQL editor from MySQL front to run the query without limit set, it returns the same records. I don't understand why in Visual Studio connecting to MySQL, I have to put a limit set in query???
Here is the query structure
select ...
from table
where...
limit 2000000
Many times the drivers enforce their own conditions. Are you using the same driver for both Visual Studio and MySQL editor?
ASKER
I don't think the same driver. But I want to use VS driver. Is there any way I remove the limit set to be able to populate the data?
I am using following connector
MySql.Data.MySqlClient.MyS qlConnecti on, MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc8896 9c44d
I am using following connector
MySql.Data.MySqlClient.MyS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see all download for 32-bit OS. I have 64-bit OS. Where to find the download link?
If you click on the dropdown and select ".NET and Mono", it will show a 'Architecture Independent' download.
ASKER
After I downloaded ".NET and Mono", I don't see .exe. file? How do I configure it into VS ADO.net
I don't know. That download does include a bunch of DLLs and a CHM Help File that contains information and programming instructions.