Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- max@host 10:13:58: ~$ mysql -h db-master.domain.local -uuser -ppw db -e '
- > SELECT
- > DISTINCT i.filesourceregexp
- > FROM db.ImportLogFiles i'
- +------------------------------------------------+
- | filesourceregexp |
- +------------------------------------------------+
- | ^[0-9]{8}_1062355673_merge_google_pbn.csv$ |
- | ^[0-9]{8}_8026062435_merge_google_pbn.csv$ |
- | ^[0-9]{8}_1062355673_store_visits_report.csv$ |
- +------------------------------------------------+
- max@host 10:14:10: ~$ mysql -h db-master.domain.local -uuser -ppw db -e '
- SELECT
- DISTINCT i.filesourceregexp
- FROM db.ImportLogFiles i' | tail -n +2
- ^[0-9]{8}_1062355673_merge_google_pbn\.csv$
- ^[0-9]{8}_8026062435_merge_google_pbn\.csv$
- ^[0-9]{8}_1062355673_store_visits_report\.csv$
- max@host 10:14:19: ~$
- [client]
- host = db-master
- user = user
- password = pass
- default-character-set=utf8
- mysql... | cat
- mysql > file; cat file
- mysql -t ... | tail -n +2
- mysql --defaults-extra-file=/some/protected/file/with/credentials
- --batch --raw --skip-column-names -e 'select...' database
Add Comment
Please, Sign In to add comment