/ Published in: SQL

Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT * FROM users INTO OUTFILE '/home/user/users.csv' FIELDS TERMINATED BY \t\' ->LINES TERMINATED BY '\n';
Comments

SELECT * FROM users INTO OUTFILE '/home/user/users.csv' FIELDS TERMINATED BY \t\' ->LINES TERMINATED BY '\n';