Guest User

Untitled

a guest
Apr 25th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. mysql> SELECT * INTO OUTFILE '/tmp/yeah.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM winit_users;
  2. Query OK, 343234 rows affected (7.48 sec)
  3.  
  4. * results in a 150 mb csv file -- pretty quick!
Add Comment
Please, Sign In to add comment