Skip navigation links

MySQL Forums :: MySQL Workbench :: Is there a way to Turn off Limit 1-1000 ?


Advanced Search

Is there a way to Turn off Limit 1-1000 ?
Posted by: Harry E Smith Jr ()
Date: November 22, 2010 03:55AM

I am using the SQL Editor in WB 5.2.30 running on Win 7 (64).

I have a table with 12,285 entries in it. I needed to do some more analys that I can better do outside of Mysql using Mathlab / Octave. I generated the following SQL queryh using WB:

select * from pata_street
into outfile 'C:/Users/Harry/Documents/MY_DB/pata_street.cvs'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

which produced a CVS version of the table information. When I checked the CVS file only 1000 records are present.

When I executed the query a second time, it error because the file existed but when I looked at the error a "hidden" Limit 0,1000 showed up. So the actual SQL query is

select * from pata_street
into outfile 'C:/MY_DB/pata_street.cvs'
LIMIT 0,1000 #added by workbench
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

I tried to override with adding my own LIMIT

select * from pata_street
into outfile 'C:/MY_DB/pata_street.cvs'
LIMIT 500 #testing purposes only.
LIMIT 0,1000 #added by workbench
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

However, I am getting a syntax error probably because there are two limits. Other than run the script from outside of WB, what other solutions exist?

Thanks for any help.
thingsmith

Options: ReplyQuote


Subject Views Written By Posted
Is there a way to Turn off Limit 1-1000 ? 5542 Harry E Smith Jr 11/22/2010 03:55AM
Re: Is there a way to Turn off Limit 1-1000 ? 1535 Devart Team 11/23/2010 02:19AM
Re: Is there a way to Turn off Limit 1-1000 ? 1979 Alfredo Kengi Kojima 11/23/2010 10:53AM
Re: Is there a way to Turn off Limit 1-1000 ? 879 Harry E Smith Jr 11/23/2010 01:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.