I have some data in one of my mysql table stored as utf8. The data is some japanese text. I need to export it to excel. Could you tell how to do it? Exporting by SELECT … INTO OUTFILE returns some plain text file. I’m not sure how to read it back in excel so that japanese character would show
Tag: into-outfile
MySQL INTO OUTFILE override existing file?
I’ve written a big sql script that creates a CSV file. I want to call a cronjob every night to create a fresh CSV file and have it available on the website. Say for example I’m store my file in ‘/…