MySQL Forums
Forum List  »  MySQL Workbench

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 ?
10755
November 22, 2010 03:55AM


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.