why I have to put limit in the query
Posted on 2013-01-10
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