Solved

why I have to put limit in the query

Posted on 2013-01-10
7
413 Views
Last Modified: 2013-01-25
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
Comment
Question by:wasabi3689
  • 4
  • 3
7 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
Many times the drivers enforce their own conditions.  Are you using the same driver for both Visual Studio and MySQL editor?
0
 

Author Comment

by:wasabi3689
Comment Utility
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
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:wasabi3689
Comment Utility
I see all download for 32-bit OS. I have 64-bit OS. Where to find the download link?
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
If you click on the dropdown and select ".NET and Mono", it will show a 'Architecture Independent' download.
0
 

Author Comment

by:wasabi3689
Comment Utility
After I downloaded ".NET and Mono", I don't see .exe. file? How do I configure it into VS ADO.net
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now