How to format content of a file to fit a SQL in-clause

SUBMITTED BY: Guest

DATE: Sept. 23, 2013, 1:41 p.m.

FORMAT: Bash

SIZE: 524 Bytes

Raw Download

HITS: 1967

Report
  1. # How to format content of a file to fit a SQL in-clause:
  2. # file: username
  3. # with content:
  4. username1
  5. username2
  6. username3
  7. username4
  8. username5
  10. # This is how to make it fit the SQL in clause:
  11. sed "s/^/'/;s/$/',/;$ s/,$//" username
  13. # output looks like:
  14. 'username1',
  15. 'username2',
  16. 'username3',
  17. 'username4',
  18. 'username5'
  20. # now use output in your SQL statement
  21. select * from users where user_name in
  22. (
  23. <insert output here>
  24. )
comments powered by Disqus