• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

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
0
wasabi3689
Asked:
wasabi3689
  • 4
  • 3
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
Many times the drivers enforce their own conditions.  Are you using the same driver for both Visual Studio and MySQL editor?
0
 
wasabi3689Author Commented:
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.MySqlConnection, MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d
0
 
Dave BaldwinFixer of ProblemsCommented:
I don't know about the limit problem.  All the MySQL connectors come from MySQL including the .NET which is on version 6.6.4 now.  You might try the newer version and see if it works better for you.  http://www.mysql.com/products/connector/
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
wasabi3689Author Commented:
I see all download for 32-bit OS. I have 64-bit OS. Where to find the download link?
0
 
Dave BaldwinFixer of ProblemsCommented:
If you click on the dropdown and select ".NET and Mono", it will show a 'Architecture Independent' download.
0
 
wasabi3689Author Commented:
After I downloaded ".NET and Mono", I don't see .exe. file? How do I configure it into VS ADO.net
0
 
Dave BaldwinFixer of ProblemsCommented:
I don't know.  That download does include a bunch of DLLs and a CHM Help File that contains information and programming instructions.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now