Hi,
I love this script! I have been having one problem though.
I cannot use the Save Results feature for a successful query. I have to page through sometimes 50 pages of results copying each.
When I click either Print to Screen or Export to File (I leave the default characters), I get the following error:
Error
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS ' at line 2.
Query: SELECT INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM invoices
I can't figure out why. Could it be something related to how the MySQL server is set up? The current version is mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)
Thanks!
Darren
I love this script! I have been having one problem though.
I cannot use the Save Results feature for a successful query. I have to page through sometimes 50 pages of results copying each.
When I click either Print to Screen or Export to File (I leave the default characters), I get the following error:
Error
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS ' at line 2.
Query: SELECT INTO OUTFILE '/usr/tmp/GTMM114235266814895577' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM invoices
I can't figure out why. Could it be something related to how the MySQL server is set up? The current version is mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)
Thanks!
Darren