Guest User

Untitled

a guest
Nov 23rd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. max@host 10:13:58: ~$ mysql -h db-master.domain.local -uuser -ppw db -e '
  2. > SELECT
  3. > DISTINCT i.filesourceregexp
  4. > FROM db.ImportLogFiles i'
  5.  
  6. +------------------------------------------------+
  7. | filesourceregexp |
  8. +------------------------------------------------+
  9. | ^[0-9]{8}_1062355673_merge_google_pbn.csv$ |
  10. | ^[0-9]{8}_8026062435_merge_google_pbn.csv$ |
  11. | ^[0-9]{8}_1062355673_store_visits_report.csv$ |
  12. +------------------------------------------------+
  13.  
  14. max@host 10:14:10: ~$ mysql -h db-master.domain.local -uuser -ppw db -e '
  15. SELECT
  16. DISTINCT i.filesourceregexp
  17. FROM db.ImportLogFiles i' | tail -n +2
  18. ^[0-9]{8}_1062355673_merge_google_pbn\.csv$
  19. ^[0-9]{8}_8026062435_merge_google_pbn\.csv$
  20. ^[0-9]{8}_1062355673_store_visits_report\.csv$
  21. max@host 10:14:19: ~$
  22.  
  23. [client]
  24. host = db-master
  25. user = user
  26. password = pass
  27. default-character-set=utf8
  28.  
  29. mysql... | cat
  30.  
  31. mysql > file; cat file
  32.  
  33. mysql -t ... | tail -n +2
  34.  
  35. mysql --defaults-extra-file=/some/protected/file/with/credentials
  36. --batch --raw --skip-column-names -e 'select...' database
Add Comment
Please, Sign In to add comment