Re: executing an SQL statement
I haven't been able to combine two statements that way. If it's going to work, you'll need a semi-colon (;) instead of a comma, but it will probably throw an error. I'm still using mysql 4.x, so I couldn't tell you whether you can do this or not.
I'm guessing the content of the two generated files will be based on different selects. I would just run two of them--it's not much extra time.
You don't need a file handle in this case because mysql is creating the files. It will handle the handle.
If you didn't provide a full path for the output file, it may have ended up somewhere other than where you expect. I'm not exactly sure where to look for it. Where ever you write the file , the logged in user will need file write permission. If the permissions aren't correct, I'm not sure whether mysql will throw an error or not. Have you tried a search for the file starting at your root folder?
Subject
Written By
Posted
Re: executing an SQL statement
April 16, 2007 01:26PM
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.