Let's say I want to save the whole list of the collations supported by MySQL into file. How can I save the result of the show collation into .txt file? The OS I'm using is Windows. I tried something like this: show collation INTO OUTFILE 'c:\aaa.txt'; or show collation > c:\aaa.txt; but it doesn't work.

2 Answers 2

select * 
into outfile 'filepath.txt'
from information_schema.collations;
C:  mysql -e "select * from information_schema.collations" >collations.txt

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.