Guest User

Untitled

a guest
Nov 21st, 2018
730
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. USERNAME=
  2. PASSWORD=
  3. DBNAME=
  4. QUERY_FILE_NAME=
  5.  
  6. mysql -u $USERNAME -D $DBNAME -p$PASSWORD -B < $QUERY_FILE_NAME | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > $QUERY_FILE_NAME.csv
Add Comment
Please, Sign In to add comment