Isisagate
asked on
Select into OUTFILE -- how do you append or delete
I have a query that will run and create the file right, however now I need to make some edits. First I need a version that will append to an existing file.... and another that will delete the file if it exists.
so say I this was the query I was using what would it look like in the above situations...
SELECT insertstatement INTO OUTFILE 'C:\\MW2MP\\conversion.sql ' from sqlinserts;
so say I this was the query I was using what would it look like in the above situations...
SELECT insertstatement INTO OUTFILE 'C:\\MW2MP\\conversion.sql
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.