MyEclipse: Running SQL txt files from SQL tool P0rridge - Nov 25, 2011 - 09:50 AM Post subject: Running SQL txt files from SQL tool
How do you run SQL script files from the MyEclispe SQL tool?
I have a number of SQL scripts in text files. I would like to mix and match native SQL in the SQL tool with my batch files.
But commands like "import" and "source", which I found on the mySQL site, are failed by the SQL tool
Thankssupport-swapna - Nov 25, 2011 - 11:00 AM Post subject:
P0rridge ,
You can copy paste the contents of the script file into the MyEclipse MySQL Editor and run them. Alternatively you can copy the script files into the project , right click on the file > Open With > MySQL Editor and execute it.
If you are looking for something else, then please elaborate on what exactly you are looking for.P0rridge - Nov 25, 2011 - 11:14 AM Post subject: running external sql files in sequence
I understand the copy and paste option.
I am generating SQL scripts from elsewhere, say to rebuild the database and to import fixed data from different sources.
I also want to write ad-hoc sql. So within MySql tool I would like to have the following lines
run script to re-build database;
run script to import data;
hand written sql statement/s here;
run script to export data;
Then I want to highlight the ones I want and ctrl F9 to run as usual.support-swapna - Nov 28, 2011 - 05:51 AM Post subject:
P0rridge ,
1) Can you share your Build ID from Help > About MyEclipse Enterprise Edition > Build ID? Also share your Operating System and version details.
2) What are the errors you are seeing ? Clear the contents of the .log file which is located at <workspace dir>/.metadata/.log , replicate the issue and paste the errors logged here.
3) Also attach a screenshot of the SQL editor to help us get a visual.