Export phpmyadmin table to MAC csv file Via Event
I am creating an event for recurring export table to csv file but it doesn't seems work. Could you please provide me some solution to this? Thanks
SELECT * FROM `email`
INTO OUTFILE '/Users/Admin/Desktop/email.csv '
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
LINES TERMINATED BY '\n'
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)